time sheet claculation
 

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

sum()?

"Frantic3d" wrote:

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

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

--
HTH

Bob Phillips

"Barb R." wrote in message
...
sum()?

"Frantic3d" wrote:

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

"Bob Phillips" wrote in
:

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

You can input in A2:D2 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.

--
HTH

Bob Phillips

"Frantic3d" wrote in message
...
"Bob Phillips" wrote in
:

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