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