View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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.