I need help creating formula(s) for timesheet below.
WORK RECORD TIME RECORD (Nearest .25 Hour)
Line JOB DESCRIPTION SA SU M T W TH F TOTALS
No. CHARGE NUMBER REG OT TOTAL
1 0 0 8.5 8.5 8 8 9 40 1 41
Cell E8 = Saturday Hours
Cell F8 = Sunday Hours
Cell G8 = Monday Hours 1) I need Cells E8 through K8 to round to
Cell H8 =Tuesday Hours - .25 hour
Cell I8 = Wednesday Hours
Cell J8 = Thursady Hours
Cell K8 = Friday Hours
Cell L8 = 40 REG Hours 2) I need Cell L8 to =40hrs (from Cells E8 tru K8)
Cell M8 = 1 OT Hours 3) I need Cell M8 to =OT Hrs (from Cells E8 tru K8)
Cell N8 = 41 Total Hours 4)I need Cell N8 to =Total Hrs (from Cells L8 & MK8)
Can anyone please help?
Bookmarks