Thread: Adding time
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
simon, uk
 
Posts: n/a
Default Adding time

Thanks guys - works a treat.

"Sloth" wrote:

Just add them up like this

=A1+B1

and use a custom format like this

[h]:mm

"simon, uk" wrote:

How do I add time, in the hr:mn format, and view total time in the same hr:mn
format when the total time is greater than 23:55?