Identifing total hours as a whole number

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob Morrison - 18 Jul 2007 18:18 GMT

I have set up a little spreadsheet using "start time" and "end time". The
resulting difference is expressed in hours and minutes. I would like to use
this figure to calculate pay. It is not doing that because of the
formating. Is there a way?

Reply to this Message

Peo Sjoblom - 18 Jul 2007 22:07 GMT

since one hour in Excel - 1/24 do as follows

=total_time*24*hourly_rate

format as currency or else you'll get a weird time value

Signature

Regards,

Peo Sjoblom

>I have set up a little spreadsheet using "start time" and "end time". The
>resulting difference is expressed in hours and minutes. I would like to
>use this figure to calculate pay. It is not doing that because of the
>formating. Is there a way?

Reply to this Message

Sandy Mann - 18 Jul 2007 22:08 GMT

Multiply the elapsed time by 24, (hours in a day) thus:

=(B1-A1)*24 and format as General or Number

or to calculate the pay:

=(B1-A1)*24* PAYRATE

and format a currency.

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

Reply to this Message