You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

📰 Apple Fitness+ unveils an exciting lineup of new ways to stay active and mindful in 2025

Offerings include new programs for strength, pickleball, yoga, and breath meditation, and a new collaboration with Strava. Learn more >

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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:45 PM

Hi Webtracer,


Numbers has interpreted 00:25:32 etc. as times of day (the Time part of the Date & Time format). Numbers will not add times. Best to use the unambiguous Duration format 0h25m32s etc.



I am working on formulas to convert Times to Durations. More later.


Regards,

Ian.



Similar questions

3 replies

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.