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

Numbers

how to add column with hours and minutes, how to add column with hours and minutes

There is this question and answer from 2012 however I can't figure out how it was done and how to do it.

Why do they have to make it so difficult in numbers?

iMac 21.5", macOS 10.13

Posted on Apr 6, 2020 9:29 AM

Reply
Question marked as Apple recommended

1) format the column as duration format:


I suggest entering durations in the format:

1w 2d 3h 4m 5s 6ms


which is read

"1 week two days three hours four minutes five seconds six milliseconds"


you only have to enter the parts you need... so e.g.

to enter one hour, just type "1h"


to enter 1 hour twenty minutes "1h 20m"


This format is less ambiguous that the format with the colons


then to add up the durations, use the sum() function:




Posted on Apr 6, 2020 9:46 AM

Similar questions

4 replies
Question marked as Apple recommended

Apr 6, 2020 9:46 AM in response to gypsy408

1) format the column as duration format:


I suggest entering durations in the format:

1w 2d 3h 4m 5s 6ms


which is read

"1 week two days three hours four minutes five seconds six milliseconds"


you only have to enter the parts you need... so e.g.

to enter one hour, just type "1h"


to enter 1 hour twenty minutes "1h 20m"


This format is less ambiguous that the format with the colons


then to add up the durations, use the sum() function:




Numbers

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