Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need to keep my columns to a minimum.
There are 5 columns for each employee (Monday-Friday). Overtime is calculated over 8 hours and I need to track how much total regular time & over time for each employee for each month. I want some kind of sum if forumula that will calculate everything over 8 and everything under 8. Mon Tue Wed Thu Fri 8 10 12 6 10 Should be 38 regular hrs, 8 Overtime Hrs (employees will not always have at least 8 hours) I've tried max/min formulas but not sure how I can do it with keeping my columns/rows to a minmum. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HOW DO I FREEZE DATA THAT CHANGES DAILY. dAILY/MONTHLY BUDGET | Excel Discussion (Misc queries) | |||
Overtime Calculation for Overtime | Excel Worksheet Functions | |||
Linking Daily Worksheet To Daily Invoice Total | Excel Worksheet Functions | |||
create a timesheet to add daily and weekly hours and overtime | 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 |