Thread: Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mandy Mandy is offline
external usenet poster
 
Posts: 55
Default Formula

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)