How to easily compute time in Excel
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)
精彩评论