G
Guest
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.
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.