Hello,

I am looking for the proper formulas for a timesheet file. I have placed notes on the attachment explaing what I am looking for.
Good luck and thanks !

Dave

Is Row 30 a total of all time per day, including Standby?

If so, you can use something like this:

=IF(SUM(J7:J26)<8,0,(SUM(J7:J26)-8)*1.5)

Hey Scott,

Half way there.
Row 30 is the total of all regular time, including standby. You rock!

Thanks!

Then the formula should work. It totals the hours excluding standby. If there are more than 8, it will calculate 1.5 of the hours over 8.

What would be the formula for the cell H30?

Sum the column and add the standby.

Sorry Scott, but I don't want that formula to total up more than 8 between cells H7-H26 and then add on cell H28. I hope that makes sense. If I just sum them up I will get overtime hours included.

Ok, no more than 8 including the standby or no more than 8 plus the standby?

If the former, than use:

=IF(Sum(H7:27)+H29>8,8,Sum(H7:27)+H29)

If the latter drop the standby row.

Perfect Scott.
Thank-you very very much for your prompt help.

Dave

As an alternate to having to SUM the range twice, this would do it one pass:

=MIN(8,Sum(H7:27)+H29)