Formula for Overtime based off the sum of 2 cells

		Microsoft Office Forums > Microsoft Excel > Excel
Formula for Overtime based off the sum of 2 cells

FAQ

Thread Tools

Display Modes

07-02-2018, 10:21 AM

kae2011

Windows 10 Formula for Overtime based off the sum of 2 cells

Office 2016

Novice

Join Date: Jun 2018

Posts: 4

regular + Drive time

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?

Tags

formula, overtime work, time calculation

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:20 AM.