Thread: Formula for Overtime based off the sum of 2 cells
View Single Post
 
Old 07-02-2018, 10:21 AM
kae2011 kae2011 is offline Windows 10 Office 2016
Novice
  
Join Date: Jun 2018
Posts: 4
kae2011 is on a distinguished road
Default regular + Drive time
Quote:
Originally Posted by Pecoflyer View Post
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?
Reply With Quote