Excel - payroll calculations
Asked By Berni
22-Feb-08 02:16 PM
I do payroll where I list hours per day I need a formula that when the hours
go over 40 that it will put 40 in one cell and the ammout of overtime in a
cell below it.
Also a formula that will look at other cells such as sick and vacation to be
part of the 40 hour week equation
MIN
(1)
Ammout
(1)
Week
(1)
Day
(1)
Rick Rothstein \(MVP - VB\) replied...
You could use this for the hours up to 40...
=MIN(40,A1)
and this for the excess...
=IF(A1>40,A1-40,"")
Rick
the following: Info on Sheet1 Operation Item A Item B Item C 1.Cut 10 min 12 min 15 min 2.Trim 22 min 19 min 17 min 3. Polish 13 min 14 min 16 min Info on Sheet2 01 / 11 02 / 11 03 / 11 Item A 9 units
trying to show inventory level dropping or raising on a weekly bases. . .something like this week 2- week 1, week 3 - week 2, week 4 - week 3, week 5 - week 4 = total, or week 1 = 12 week 2 = 15. . . . 3 week 3 = 4. . . . (1) week
Countdown Clock Excel I have a countdown clock in Excel that counts down from 5 min, 10 min, 15 min, 20 min. I need 30 min, 45 min, 60 min, and 90 min added to it. Can anyone help me? Excel Miscellaneous Discussions Selection.Interior.ColorIndex (1) ActiveCell
looking for average times for surgical cases. SURGEON PROCEDURE TIME AVERAGE Dr Smith Appendix 92 min 79.25 min 85 min 75 min 65 min Dr. Jones Gall Bladder 62 min 66.22 min 58 min 69 min 91 min 51 min Would anyone know how I could find the average