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.

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

In Numbers, how can I convert seconds to hours/minutes?

I can convert seconds to Hours as a decimal, eg, 150 seconds = 2.5 hours, but how to I convert it to 2:30, ie, 2 hours 30 mins.

Posted on Oct 20, 2022 5:52 AM

Reply
Question marked as Top-ranking reply

Posted on Oct 20, 2022 6:12 AM

One way is to do something like this:



=DURATION(,,,B2)


Or, instead of entering your value as a decimal 150 you can enter the minutes using the special duration entry shorthand: 150m


Then format that as shown in the Cell pane.


To prevent confusion with Data & Time (a point in time as opposed to a segment of time) I often format Duration with 0h 0m instead:





SG

2 replies
Question marked as Top-ranking reply

Oct 20, 2022 6:12 AM in response to kanga66x

One way is to do something like this:



=DURATION(,,,B2)


Or, instead of entering your value as a decimal 150 you can enter the minutes using the special duration entry shorthand: 150m


Then format that as shown in the Cell pane.


To prevent confusion with Data & Time (a point in time as opposed to a segment of time) I often format Duration with 0h 0m instead:





SG

In Numbers, how can I convert seconds to hours/minutes?

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