MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How do you add (lap) times?

Posted by Ross on December 09, 2001 12:28 AM

I'm trying to add 1:45:75 to 1:05:72 (for eg).
(That's 1 minute 45.75 seconds).
Does anyone know how to do this in Excel?
Thanks a lot,

Posted by Ian Bartlett on December 09, 2001 2:06 AM


Format the cells that contain your times as [h]:mm:ss

Using the Sum() function, or just plain old A1 + B1 should give the answer that you expect. Using the [h] format will show hours in excess of 24 as the correct number of hours (eg. 26:15:10), in case you need it.



Posted by Mark W. on December 10, 2001 2:35 PM

Ross, enter you times as 1:45.75 and format as

1:45.75 + 1:05.72 = 2:51.47