Adding two times values together
=A2+(B2/24)
format as time
where A2 holds the time value and B2 the decimal value
--
Regards,
Peo Sjoblom
"Stuart" wrote in message
...
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.
|