Adding running times
I'm trying to add my split times for each kilometer for a total of 5 km, eg.
0:5:22:03 (5 minutes: 22.3 seconds) + 0:5:40:20 etc. What is the formula to add these to get 0:11:02:23 - I keep getting 0:0:0:0 Thanks |
Adding running times
Format the cells where you enter your times as m:ss.00
Enter the 100th secs as a decimal: A1 = 5:22.03 A2 = 5:40.20 Then, just use a SUM formula: =SUM(A1:A2) Or: =A1+A2 Format the SUM cell as [m]:ss.00 -- Biff Microsoft Excel MVP "stormy weather" wrote in message ... I'm trying to add my split times for each kilometer for a total of 5 km, eg. 0:5:22:03 (5 minutes: 22.3 seconds) + 0:5:40:20 etc. What is the formula to add these to get 0:11:02:23 - I keep getting 0:0:0:0 Thanks |
Adding running times
Try entering the data as
A1: 0:5:22.3 A2: 0:5:40.2 Then you can add the values: A6: =SUM(A1:A5) Format the cells with Format/Cells/Number/Custom h:mm:ss.0 In article , stormy weather wrote: I'm trying to add my split times for each kilometer for a total of 5 km, eg. 0:5:22:03 (5 minutes: 22.3 seconds) + 0:5:40:20 etc. What is the formula to add these to get 0:11:02:23 - I keep getting 0:0:0:0 Thanks |
Adding running times
Are you entering the fractions of a second as a decimal or with a colon like
in your example? Should be 0:5:22.03 and 0:5:40.20 Regards, OssieMac "stormy weather" wrote: I'm trying to add my split times for each kilometer for a total of 5 km, eg. 0:5:22:03 (5 minutes: 22.3 seconds) + 0:5:40:20 etc. What is the formula to add these to get 0:11:02:23 - I keep getting 0:0:0:0 Thanks |
Adding running times
Thank you all -- It works!
"OssieMac" wrote: Are you entering the fractions of a second as a decimal or with a colon like in your example? Should be 0:5:22.03 and 0:5:40.20 Regards, OssieMac "stormy weather" wrote: I'm trying to add my split times for each kilometer for a total of 5 km, eg. 0:5:22:03 (5 minutes: 22.3 seconds) + 0:5:40:20 etc. What is the formula to add these to get 0:11:02:23 - I keep getting 0:0:0:0 Thanks |
All times are GMT +1. The time now is 09:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com