|
|
#1
06-29-2018, 08:42 AM
|
|||
|
|||
Formula for Overtime based off the sum of 2 cells
Hello! I am in need of help on a formula i uploaded my spreadsheet to show what i need. I need formulas for the REG, Drive, & OT columns to show the values of reg hours + drive hours over 40 = all OT hours OR is there an overall simpler way to do this? 
|
| Tags |
| formula, overtime work, time calculation |
|
|
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 |
Windows 10 
Office 2016
Threaded Mode