appletoys132 Author

Level 1

5 points

Converting time to decimal

I'm trying to convert the duration of time worked to a decimal so that I may multiply it by my rate, but I can't seem to figure out how to do this. There is a very old thread about this (9 years), so I'm wondering if there is an update. Can anyone help?

MacBook Air 13", macOS 10.15

Posted on Jan 23, 2020 8:19 PM

Reply

Similar questions

Times are rounding up How do I remove seconds from a time calculation? The PM add should be 10:30 for a GTTL of 31:31.
724 2
In Numbers, how can I convert seconds to hours/minutes? I can convert seconds to Hours as a decimal, eg, 150 seconds = 2.5 hours, but how to I convert it to 2:30, ie, 2 hours 30 mins.
1150 2
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.
625 2

1 reply

Level 7

21,951 points

Jan 23, 2020 9:24 PM in response to appletoys132

Hi appletoys,

The DUR2HOURS function is your friend.

Formula in F2 =DUR2HOURS(E2)

Formula in G2 =F2×Table 2::A$2

But in Numbers 6.1 (and later) you don't need that step. Simply multiply the duration in column E by the hourly rate in Table 2.

I can't remember if this is an update, or if it has always worked.

Formula in F2 =E2×Table 2::A$2

Regards,

Ian.

Reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Converting time to decimal

Welcome to Apple Support Community

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

Learn more Sign up