time calculate

[dave elenor]

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]

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.

 

[swatsp0p]

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

 

[dave elenor]

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

 

[Peo Sjoblom]

C2 should be 14:00

in E2 use

=C2*24*D2

format as currency