Hi!

I need help on calculating overtime hours in Excel.

The conditions that are needed are as follows:
1. If OT hours is 1 hour - it must translate to 0
2. If OT hours is more than 1 hour
1:20 = must translate to 1
1:30 = must translate to 1.5
1:40 = must translate to 1.5
2:00 = must translate to 2.0
2:15 = must translate to 2.0
2:30 = must translate to 2.5
and so on...

Basically, if it is less than 1 hour, there is no Overtime. But, if exceeds 1 hour, OT computation is by increments of 30 minutes.


Thanks!


EggHeadCafe - Software Developer Portal of Choice
RSS / ATOM Feed Autodiscovery Class
http://www.eggheadcafe.com/tutorials...autodisco.aspx