Overtime Calculation
 

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

Overtime Calculation
 

=FLOOR(A1*24,0.5)


"Lorraine Tiu" wrote:

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
.