One additional question with regards to the formula,

=IF(D1<10/24,D1-"0:30",D1-"1:00")

Is there a way to have it so that at 10hours it would still deduct 30 minutes, but at 10:01 hours it would deduct one hour?

How could I specify the exact time when a 1 hour deduction takes place?

Thanks for any help.

Dihs