I have trying to make up a timesheet to calculate times and wage due
1. 06:00 to 20:00 = amount of hrs worked, I would like 14.00 instead of
14:00 hrs
2. To be able to calculate each day to total hourly week
3. Calculate to hours by ?7.60 per hour
cheers
JE McGimpsey - 16 Feb 2005 13:52 GMT
XL stores times as fractional days, so to get 14.00, multiply the time
by 24:
A1: 06:00
A2: 20:00
A3: =(A2-A1)*24 <=== 14.00 when formatted as a number
Note that if your times span midnight, the "later" time (say, 3:00 am =
0.125) will be smaller than the "earlier" time (say, 9:00 = 0.875). You
can use the fact that boolean (TRUE/FALSE) values are coerced to 1/0 in
math operations:
A3: =(A2-A1+(A2<A1))*24
or use the MOD function:
A3: =MOD(A2-A1,1)*24
You can get a total using the SUM() function, e.g:
=SUM(A3:G3)
then the total pay is calculated by multiplying that SUM by your rate.
> I have trying to make up a timesheet to calculate times and wage due
>
[quoted text clipped - 6 lines]
>
> cheers
swatsp0p - 16 Feb 2005 14:28 GMT
Assuming your times are in A1 (start time) and B1 (end time), in C1
enter:
=B1-A1*24 Format C1 as Number (2 decimals)
Pay rate in D1
Gross Pay in E1 is:
=C1*D1 Format E1 as your preferred monetary form.
Good Luck

Signature
swatsp0p
dave elenor - 16 Feb 2005 16:29 GMT
A2 Start Time 06:00
B2 Finish Time 20:00
C2 Total Hours Worked
D2 Per Hour ?7.60
E2 Total Wage for that day
When I have entered calulation into C2 =(B2-A2) result comes back as
14:00 or if I change format to number result is 14.58
>I have trying to make up a timesheet to calculate times and wage due
>
[quoted text clipped - 6 lines]
>
> cheers
Peo Sjoblom - 16 Feb 2005 16:53 GMT
C2 should be 14:00
in E2 use
=C2*24*D2
format as currency

Signature
Regards,
Peo Sjoblom
> A2 Start Time 06:00
> B2 Finish Time 20:00
[quoted text clipped - 15 lines]
> >
> > cheers