convert 6:30 to 6.5
How to covert worked time 6:30 to a decimal number 6.5
iMac 21.5″, 10.15
Question marked as
Best reply
If the 6:30 is a duration value of 6 hours and 30 minutes, use the DUR2HOURS function to change it into decimal hours, which would be 6.5.