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

converting hours to numbers

I have a cell in a sheet that tallies a number of cells with time durations ( 10h 30m, etc...) and I would like to put a cell next to it that reads that as a number (for example 10h 30m as 10.5 ). I convert the cell type from duration to number but it doesn't stay.

Mac Pro, OS X 10.11

Posted on Nov 1, 2019 12:11 PM

Reply
Question marked as Best answer

you can use the Dur2Hours function.


there are a whole lot of extra functions dealing with durations in numbers that dont exist in other programs.


You can see the full list of functions here:

https://www.apple.com/mac/numbers/compatibility/functions.html


Jason


Posted on Nov 1, 2019 12:25 PM

1 reply

converting hours to numbers

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