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.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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) ?
iPad Pro, iPadOS 16
Wow, YellowBox, You have completely solved it.
Just a follow up question:
Is there a formula that can happen if there is no lunch?
Suppose there is no lunch time, F8 and E8 would be left blank.
I can not use 00:00 as that would be read as midnight.
Using 00:00 was my work around, however as stated, one may also read that as midnight and I would like to avoid confusion.
Ian,
Thank you in advanced. Maybe you could also solve this question/issue.
In the case where start time is 14:00, however end time is in the morning…let’s say 03:00. Would the formula work?
I have input the values and getting an odd outcome. Is this because of the 24hr clock computation?
Any help will be greatly appreciated!
I will attach the problem:
Hi Gnodneit,
The function DUR2HOURS is your friend.
Formula in K8: DUR2HOURS((I8−D8)−(F8−E8))
Regards,
Ian.
I have this so far, and I want to convert K colour to decimal.
How does one convert time into decimal? Time worked minus lunch.
