How do I add a column of time values

I keep a spreadsheet of my workouts. I track lots of information, one of which is duration


In Excel and Google Docs, no problem. When I convert my Excel spreadsheet to Numbers the column displays an error that says "The formulas Arguments can only include one Date Value"


Example: Rows 2-32 contain various time values such as:


00:25:32 (0h25m32s)

01:36:59 (1h36m59s)


That should add up to 02:02:21 ... Excel and Google Docs it's just a simple =Sum(<first row>:<last row>)


(the 00:00:00 is the only thing entered in the columns, the ( ) in the examples is just for clarification of the data)


Numbers doesn't like that however and just displays the error above ...


What simple thing am I missing? Or is it not so simple and I'm just not seeing what I need ...


Thanks!

Posted on Mar 6, 2021 7:39 PM

Reply
Question marked as Top-ranking reply

Posted on Mar 6, 2021 8:55 PM

More:


If all the Times use 2 digits for hours, minutes, seconds, separate them out and recombine them into Durations like this:



Formula in C2: LEFT(B2,2)

Formula in D2: MID(B2,4,2)

Formula in E2: RIGHT(B2,2)

Formula in F2: DURATION(,,C2,D2,E2)

The commas at the beginning take the place of the non-existent Weeks and Days.


Regards,

Ian.

Similar questions

3 replies
Question marked as Top-ranking reply

Mar 6, 2021 8:55 PM in response to Yellowbox

More:


If all the Times use 2 digits for hours, minutes, seconds, separate them out and recombine them into Durations like this:



Formula in C2: LEFT(B2,2)

Formula in D2: MID(B2,4,2)

Formula in E2: RIGHT(B2,2)

Formula in F2: DURATION(,,C2,D2,E2)

The commas at the beginning take the place of the non-existent Weeks and Days.


Regards,

Ian.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How do I add a column of time values

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.