time sheet claculation

[Frantic3d]

Thanks for piping in Biff.

As a fella said above. I'm lazy.
Across my spreadsheet. I have the typical In Out In Out Total.
Down the right side I have the total for the days.
I want it to total at the bottom of the last right collumn.

Being lazy I would only like to enter the various times from the numeric
keypad. The decimal being used as the colon.
I can get the formula =(A2-B2) + (D2-C2). This will give me the correct
results using 24 time. Across the sheet. But I'm at a lose for getting
the proper total.

TIA
Frantic3D

 

[Guest]

sum()?

 

[Bob Phillips]

This will give decimal hours

=(TIME(INT(B2),MOD(B2,1)*100,0)-TIME(INT(A2),MOD(A2,1)*100,0)+TIME(INT(D2),M
OD(D2,1)*100,0)-TIME(INT(C2),MOD(C2,1)*100,0))*24

 

[Frantic3d]

This will give decimal hours

=(TIME(INT(B2),MOD(B2,1)*100,0)-TIME(INT(A2),MOD(A2,1)*100,0)+TIME(INT(
D2),M OD(D2,1)*100,0)-TIME(INT(C2),MOD(C2,1)*100,0))*24

Will the formula allow me to input in decimal form>

 

[Bob Phillips]

You can input in A22 in decimal form, like 10.3 is 10:30, 10.45 is 10:45,
etc, but it will return decimal hours, so a total of 8 hours 30 mins will
return as 8.5. This is easier for calculations, such as pay.