Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Overtime Calculation for Overtime
I have a timecard spreadsheet in excel that automatically calculates how much
an employee worked on a day. ex: Clock in Lunch out Lunch in End of day TOTAL 8:30 am 12 pm 1 pm 6:00 p 8.50 I am trying to create a column in which the overtime will be carried onto another column. So it will look something like this: Clock in Lunch out Lunch in End of day Reg Hrs OT 8:30 am 12 pm 1 pm 6:00 p 8 .50 Is there a way in which it will done like this atumatically? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
overtime calculation | Excel Discussion (Misc queries) | |||
Overtime Calculation | Excel Discussion (Misc queries) | |||
overtime calculation | Excel Worksheet Functions | |||
Overtime Calculation??? | Excel Worksheet Functions | |||
=SUMPRODUCT((Overtime!$J$6:$GY$6-DAY(Overtime!$J$6:$GY$6)+1=A25)*(Overtime!$J$7:$GY $2 | Excel Worksheet Functions |