Formula for Overtime based off the sum of 2 cells

Pecoflyer · #1 06-30-2018, 12:14 AM

I reattached the file

If it still does not work enter =MAX((SUM($E$5:E5)-40),0) in M5 and pull down
Also change M12 to =M11

kae2011 · #2 07-02-2018, 10:21 AM

Quote:

Originally Posted by Pecoflyer

I reattached the file
If it still does not work enter =MAX((SUM($E$5:E5)-40),0) in M5 and pull down
Also change M12 to =M11

that did work, however is there a formula that i could use in k5 to k11 and L5 to L11 to show total of regular hours + drive hours up to 40. to show the values that i manually entered into those columns?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Reposition Cells in a Column based on another	hiwire03	Excel Programming	1	03-03-2018 01:09 AM
Fill cells based on value	hiwire03	Excel	6	11-09-2017 09:16 AM
Merging 2 different cells containing IF formula & change in cell values based on multiple time frame	jay_excel	Excel	0	07-29-2017 11:04 PM
Need help with an IF formula, which is based on adjacent cells being in the Top 30% of a range	FarStar	Excel	17	07-26-2017 07:55 AM
Conditional formating all cells in an array based on adjacent cells	deejay	Excel	6	12-20-2016 12:00 PM