Counting numbers in changing arrays

%3CLINGO-SUB%20id%3D%22lingo-sub-2650531%22%20slang%3D%22en-US%22%3ECounting%20numbers%20in%20changing%20arrays%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2650531%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3CBR%20%2F%3EI%20need%20help%20with%20a%20payroll%20query.%3CBR%20%2F%3EI%20need%20to%20calculate%20overtime%20in%20each%20pay%20period.%20Each%20person%20can%20work%20over%2010%20hours%20in%20a%20shift%20one%20time%20per%20pay%20period%2C%20but%20the%20second%2C%20third%20or%20fourth%20time%20they%20do%20it%20they%20receive%20overtime.%20How%20do%20I%20get%20excel%20to%20calculate%20the%20overtime%20for%20each%20pay%20period%3F%3C%2FP%3E%3CTABLE%20border%3D%220%22%20width%3D%22128%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2264%22%20height%3D%2280%22%3EPay%20Period%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EHours%20Worked%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2221%22%3E43114%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2221%22%3E43114%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2221%22%3E43114%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2221%22%3E43114%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2221%22%3E43114%3C%2FTD%3E%3CTD%3E12.5%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2221%22%3E43114%3C%2FTD%3E%3CTD%3E12.5%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2221%22%3E43114%3C%2FTD%3E%3CTD%3E12.75%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2221%22%3E43121%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2221%22%3E43121%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2221%22%3E43121%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2221%22%3E43121%3C%2FTD%3E%3CTD%3E12.5%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2221%22%3E43121%3C%2FTD%3E%3CTD%3E12.5%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2221%22%3E43121%3C%2FTD%3E%3CTD%3E12.5%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2221%22%3E43121%3C%2FTD%3E%3CTD%3E12.75%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3CBR%20%2F%3ETim%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2650531%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi,
I need help with a payroll query.
I need to calculate overtime in each pay period. Each person can work over 10 hours in a shift one time per pay period, but the second, third or fourth time they do it they receive overtime. How do I get excel to calculate the overtime for each pay period?

Pay PeriodHours Worked
431140
431140
431140
431140
4311412.5
4311412.5
4311412.75
431210
431210
431210
4312112.5
4312112.5
4312112.5
4312112.75

 

Thanks,
Tim

0 Replies