Thread: Adding time
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Sloth
 
Posts: n/a
Default Adding time

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?