Adding two times values together
Thanks.
"Dave Peterson" wrote:
You're "other words" are confusing me...
If A1 contains 17:00:00 (hh:mm:ss) and A2 contains 3.25:
I could use this formula to return 20.25:
=(A1+A2/24)*24
(Make sure the result is not formatted as time)
I could use this formula to return 20:15:00
=A1+A2/24
(and format this as HH:MM or HH:MM:SS)
Stuart wrote:
I want to add two cells together, one with a time of 17:00 and another with a
duration of 3.25 hours (3 and quarter hours). I want the answer to equal
20.25.
In otherwords, I want to add 3.25 hours onto 5:00pm to give me 8:15 in the
evening.
Any help appreciated.
--
Dave Peterson
|