View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
ELIZE TALJAARD ELIZE TALJAARD is offline
external usenet poster
 
Posts: 1
Default how to calculate time for a payroll sheet.

My time sheet is set up like the brief example below:

A B C D E
F
1 DAY: DATE: TIME IN: TIME OUT: Total Hours:
2 Thursday 1 11:12:00 01:58:00 = ?????-formula??
3 Friday 2 10:44:00 17:43:00 = ?????-formula??

I would like to know which formula to enter in F2, F3, etc. to be able to
obtain the total hours worked per day.

Help would be much appreciated. THANKS, ELIZE TALJAARD