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.
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.
select cell D2, then type, or copy and paste from here, then formula:
=DUR2MINUTES(C2−B2)
Here is what came up with:
I assume the question relates to payroll or something like that…
two cells contain time, say A1 contains shift START time and A2 contains shift end time…
=A2-A1 will produce time worked in h:m say in A3
DUR2MINUTES(A3)÷60
will produce decimal number of time worked
If ending date-time is in C2 and beginning date-time in B2, then:
=DUR2MINUTES(C2-B2)
Gives you the number of minutes in decimal form.
SG
Any of these will do it:
DUR2HOURS
DUR2MINUTES
DUR2SECONDS
etc.
Thank you, Badunit. How do I link the time value (in minutes, if you like) to the formula?
Dear Lemon,
I think this thread is stalled because we don't know what you mean by "How do I link the time value (in minutes, if you like) to the formula?".
Could you expand on that?
Jerry
Convert time values to decimal value.
