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.

Subtracting time to give me hours in decimals in Numbers

I am setting up a time sheet and want to subtract on time from another to give me hours with decimal places instead of minutes. For example 14:30 - 13:00 would be 1.5 hours, not 1 hour 30 minutes. Any solution?


Posted on Nov 21, 2020 2:21 PM

Reply
Question marked as Top-ranking reply

Posted on Nov 21, 2020 3:05 PM

DUR2HOURS function

2 replies

Subtracting time to give me hours in decimals in Numbers

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