Calculating Times in Numbers
I want to convert times such as 08:30 into decimals like 8.5. But it seems Numbers cannot calculate this. In Excel I simply would add a formula "a5*24".
Can it be done?
Mac mini, macOS 14.4
Question marked as
I guessing you are referring not to a point in time (Date & Time) but to elapsed time (Duration).
Numbers has a DUR2HOURS function that converts a Duration to its decimal equivalent.
So if you have a Duration in cell A5 then =DUR2HOURS(A5) will give you the equivalent in decimal hours.
SG