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.
Question marked as
Best reply
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