Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am making a pay calculator spreadsheet.
I am trying to figure out the formula that will help me to calculate overtime. So if I have 41 hours listed then one cell will show with 40hrs and the another cell will show if over 40 the amount. So if I make 14.90hr and I have worked 42hrs. A1 shows 40hrs at 596.00 A2 shows 2hrs at 44.70(22.35hr) |