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

Best reply

Badunit

Level 7

26,590 points

Posted on Nov 21, 2020 3:05 PM

DUR2HOURS function

View in context

Similar questions

Convert time values to decimal value. In Excel, I can subtract one time value from another and with the result convert it into a decimal. I can manage the first part of this process, but I cannot convert my hour and minutes value into a decimal value. How do you do that in Numbers? Thank you.
539 6
How does one convert time into decimal? Time worked minus lunch. Hello, Thank you for the help in advanced. I am having trouble on Numbers…. I am trying to convert time to decimal. I have a start time, lunch start time, lunch end time, and finish time. I only want to account for total number of hours worked but in a decimal format. Ex: Time In: 07:00 Lunch Start:13:30 Lunch End 14:00 End Time: 20:00 I would like K8 =(End Time - Start Time)-(Lunch end -Lunch Start) ?
311 4
Subtract two times in apple numbers "ERROR" i have a pop-up menu with time from 15:45 till 20:00 and i have another one with the same time i wanna use it to calculate the extra time i work but if i start the pop-up menu with Blank i always get an error when i try to subtract for example 17:45 - 15:45 if both cells are blank there is no error but the moment i put a time in one cell i get the error. some help please, Thank you.
148 5

2 replies

Best reply

Badunit

Level 7

26,590 points

Nov 21, 2020 3:05 PM in response to joefromvaughn

DUR2HOURS function

Nov 21, 2020 3:15 PM in response to Badunit

Thank you.

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 ID.

Learn more Sign up