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

Make a formula to convert time to decimals

I am trying to set up a Numbers spreadsheet to convert Clock in and Clock out times to Decimal numbers.


So Clock in at 8:00 am Clock out at 10:15 would show 2.25


The formula's I've tried to create give me a Syntax error. I really am new to even creating formulas, but Trying to help other employees keep track of hours worked.

Posted on Jan 7, 2019 10:00 AM

Reply
Question marked as Apple recommended

use the formula:

=DUR2HOURS(C2-B2)

Posted on Jan 7, 2019 1:22 PM

2 replies
10 replies

Make a formula to convert time to decimals

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.