View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default Adding time durations

One duration in A1, the other in A2:

=A1+A2

Format Custom as [s] for seconds, [m]:ss for mintues and seconds and
[h]:mm:ss for hours, minutes and seconds

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Foghat" wrote in message
...
I want to be able to calculate time durations then add them all together

i.e hh:mm:ss 00:04:23 is 263 seconds and 00:05:35 is 335 seconds,
the
sum of these is 598 seconds or 00:09:58

Can anyone help as I dont even know where to begin

Many thanks