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.

Level 1

4 points

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.

Posted on Jul 5, 2023 12:52 PM

Top-ranking reply

Level 7

20,975 points

Posted on Jul 6, 2023 4:40 AM

Hi cigarete,

Using your example 4:36 PM to 9:44 PM in Row 2:

The function DUR2HOURS is your friend.

Formula in D2: DUR2HOURS(C2−B2)

Fill down.

Column D is a number.

Sorry to disappoint you, but to achieve 5.25 hours, you must punch out at 9:51 (row3).

However, I see the point of your question 😎.

Regards,

Ian.

View in context

Similar questions