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

⚠️

Top-ranking reply

Badunit

Level 7

29,248 points

Posted on Aug 15, 2020 1:23 PM

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.

View in context

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!
2 years ago 289 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.
1 year ago 285 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.
2 years ago 573 2

1 reply

Sort By:

⚠️

Top-ranking reply

Badunit

Level 7

29,248 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

Quick Links

convert 6:30 to 6.5

Similar questions