Conditional formula: Subtracting time

Hi all,

First time poster and new member, but I have often found the answer on here before, so many thanks for that!

I am working on a simple spread sheet where employees register their overtime for approval from management.
Part of the overtime process is that the first hour overtime claimed in a week is forfeit, so I want to create a formula that will auto calculate that to ensure when the employee inputs their time, the gross weekly total will automatically be deducted by an hour.
This is my first time working with an =IF formula, and I had thought it would work out like this, but it doesn't:

=IF(I39:I45=">00:01",01:00,00:00)

Attached is the layout I am working on. I2:I8 auto calculates to the weekly gross I9. If there is any value put into that column greater than 00:01, I would like the value in J9 to be 01:00. If there is no value in I2:I9, then I want the value in J9 to be 00:00. I can then get it to subtract J9 from I9 giving the net value in K9.
I need the 00:00 value as an answer because this will affect the monthly total otherwise.

Any help will be greatly appreciated!

Dave

You can use this formula in J9:

=IF(I9>0,TIME(1,0,0),0)

Hope this helps.

Pete

Originally Posted by Pete_UK

You can use this formula in J9:

=IF(I9>0,TIME(1,0,0),0)

Hope this helps.

Pete

That's solved it, thanks Pete!