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.
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.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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.
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
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
Thanks, that worked perfectly!
In Numbers, how can I convert seconds to hours/minutes?