You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

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

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
Question marked as Top-ranking reply

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.

1 reply

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.