TIMESHEET FORMULA
 

WHAT IS A FORMULA TO ADD DIFFERENCES BETWEEN WORK HOURS IN A WEEK?
FOR EXAMPLE ON MONDAY AN EMPLOYEE WORKED FROM 6:30 AM TO 3:30 PM WITH A 1
HOUR LUNCH BREAK THAT WOULD TOTAL TO 8 HOURS. IF THE TIME WAS THE SAME FOR
THE FOLLOWING 4 DAYS, THE TOTAL FOR THE WEEK WOULD BE 40 HOURS, BUT I CAN'T
COME UP WITH A FORMULA.

First, you really, really need to turn off your CAPS LOCK. It makes your
post very hard to read.

Check out

Times, Adding And Subtracting
http://cpearson.com/excel/datetime.htm#AddingTimes

and

Timesheets, Working With Regular And Overtime Hours
http://cpearson.com/excel/overtime.htm


In article ,
"JANET" wrote:

WHAT IS A FORMULA TO ADD DIFFERENCES BETWEEN WORK HOURS IN A WEEK?
FOR EXAMPLE ON MONDAY AN EMPLOYEE WORKED FROM 6:30 AM TO 3:30 PM WITH A 1
HOUR LUNCH BREAK THAT WOULD TOTAL TO 8 HOURS. IF THE TIME WAS THE SAME FOR
THE FOLLOWING 4 DAYS, THE TOTAL FOR THE WEEK WOULD BE 40 HOURS, BUT I CAN'T
COME UP WITH A FORMULA.