View Single Post
  #1   Report Post  
Frantic3d
 
Posts: n/a
Default 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