开发者

How to easily compute time in Excel

开发者 https://www.devze.com 2022-12-21 19:15 出处:网络
I want to do quick calculations in Excel.I have a cell (A1) with 50:00:00.I do =A1+1 and get 74:00:00.So, I guess 1=24 hours=1 day.However, I try =A1+1:23:45 and get an error.Is there an easy way to a

I want to do quick calculations in Excel. I have a cell (A1) with 50:00:00. I do =A1+1 and get 74:00:00. So, I guess 1=24 hours=1 day. However, I try =A1+1:23:45 and get an error. Is there an easy way to add hours to hours in Excel? If not, do you have a better tool?

Please don't 开发者_运维问答say something like =A1+1/24+23/24/60+45/24/60/60. That's not easy in my book.


Just use =A1+Time(1,23,45) for this.


You can use the Time function which takes as parameters, hour, minute, seconds, respectively.

So to ad 1 hour to the date in A1, you would type = A1 + Time(1,0,0)

0

精彩评论

暂无评论...
验证码 换一张
取 消