Level 1

8 points

convert 6:30 to 6.5

How to covert worked time 6:30 to a decimal number 6.5

iMac 21.5″, 10.15

Posted on Aug 15, 2020 12:48 PM

Reply

Similar questions

numbers question Does anyone know how to easily convert clock in/out times to total hours & minutes? For example, if I clocked in to a job at 8:57 AM and clocked out at 11:23 - I am looking for a way to convert this to hours and minutes (2.26 or 2 hours & 26 minutes). TIA!
548 3
Numbers Looking for time keeping. I need to be able to take a punch in / out time and convert it to a number... 4:36 PM to 9:44 PM = 5.25 hours.
512 2
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.
982 2

1 reply

Level 7

30,342 points

Aug 15, 2020 1:23 PM in response to creww1

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.

Reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

convert 6:30 to 6.5

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up