Calculating time and pay rates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Django Cat - 07 Jan 2008 09:42 GMT

On a project timekeeping spreadsheet, I have an accumulating 'hours
worked' field formatted as [hh]:mm. I'd like to be able to multiply
this by an hourly pay rate to show money earned so far, and then
display this with currancy format.

Any help with an easy way of doing this much appreciated.

DC
--

Reply to this Message

Bob Phillips - 07 Jan 2008 10:00 GMT

=time_cell*24*pay_rate

and just format as currency through Format>Cells menu

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> On a project timekeeping spreadsheet, I have an accumulating 'hours
> worked' field formatted as [hh]:mm. I'd like to be able to multiply
[quoted text clipped - 4 lines]
>
> DC

Reply to this Message

Django Cat - 08 Jan 2008 12:24 GMT

Thanks Bob, that works! I'm not sure I understand the logic of *why*
it works, but it does!

DC

> =time_cell*24*pay_rate
>
[quoted text clipped - 9 lines]
> > DC
> > --

Reply to this Message

Bob Phillips - 08 Jan 2008 15:00 GMT

It is because time is held as a fraction of 1 day, so 12:00 is held as 0.5,
8.00 AM is 0.3333, etc. So to get the decimal number of hours,you multiply
by 24 (.5*24 = 12, .33333*24 is 8 and so on). You can then multiply that by
the pay rate.

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Thanks Bob, that works! I'm not sure I understand the logic of *why*
> it works, but it does!
[quoted text clipped - 14 lines]
>> > DC
>> > --

Reply to this Message

Django Cat - 08 Jan 2008 22:46 GMT

> It is because time is held as a fraction of 1 day, so 12:00 is held
> as 0.5, 8.00 AM is 0.3333, etc. So to get the decimal number of
> hours,you multiply by 24 (.5*24 = 12, .33333*24 is 8 and so on). You
> can then multiply that by the pay rate.

OK, you live and learn! Thanks again.

DC

--

Reply to this Message