Adding time durations

F

Foghat

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
 
N

Niek Otten

One duration in A1, the other in A2:

=A1+A2

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

Mike H

Hi,

Times in Excel are numbers and these are fromatted so we can see them as a
time we recognise. So
with the 2 times below in A1 & a2

00:04:23
00:05:35

=Sum(A1:A2) will show 00:09:58

If you want to see that as seconds format as ss

When adding times they will roll over back to zero if the hours > 24. To
avoid this format the cell with

[hh]:mm:ss

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating Work Time 7
years-months-days-hours 8
Formatting time 2
dd:hh:mm:ss 2
Specific hours worked between two time intervals 6
Sum of minutes and seconds times price? 2
Conditional Time Calculation 10
Aggregate the time data (mm/dd/yyyy:hh:mm:ss) into the 3 hours range 0

Top