Excel if functions

**janellejulian** · 07-17-2012, 03:41 PM

Im trying to do a function where on a two week time card if in the first week there is over 40 hours the extra goes as over time and same with the second week how would i do this?

**ben_hensel** · 07-17-2012, 04:05 PM

Generally...

pay = IF(hours < 40, hours * pay_rate, 40 * pay_rate + (hours - 40) * overtime_pay_rate)

something like that?

**janellejulian** · 07-17-2012, 04:09 PM

K SO ON THE EXAMPLE IF THE HOURS FOR THE TOTAL WEEK IS OVER 40 IT SHOULD GO INTO OT DOES THAT MAKE SENSE? SO EVEN IF THE FIRST WEEK THEY HAVE 50 HRS AND THE SECOND WEEK THEY HAVE 30 THE FIRST WEEK THEY SHOULD GET PAID OT PAY FOR THE 10 EXTRA HOURS. BUT ITS NOT CALCULATING IT LIKE THAT JUST IF THE TOTAL OF THE 2 WEEKS IS OVER 80 HOURS
PER-DIUM 103.25 Reg
$40.00 Vacation 19.25 OT

Week 1 Week 2 Grand
Day 1 Day 2 Day 3 Day 4 Day 5 Day 6 Day 7 Total Day 8 Day 9 Day 10 Day 11 Day 12 Day 13 Day 14 Total Total
OFF STAWBER OFF OFF

7:00 7:00 7:00 7:00 7:00 8:15 7:00 7:00 7:00 3:00 7:00
20:00 17:45 21:00 17:00 18:30 19:30 21:00 21:00 11:30 16:30 13:00

0:00 13:00 10:45 14:00 10:00 11:30 0:00 59:15:00 11:15 14:00 14:00 4:30 13:30 0:00 6:00 63:15:00 122:30:00

0.00 13.00 10.75 14.00 10.00 11.50 0.00 59.25 11.25 14.00 14.00 4.50 13.50 0.00 6.00 63.25 122.50

**Miraun** · 07-17-2012, 04:14 PM

1) Caps lock key

2) Ben's equation was right, it just included the overtime pay, but without a sample workbook, we won't be able to give you one that you can drop into your spreadsheet. Copy/paste of the cells is a pain, just attach an example workbook devoid of sensitive information.