Overtime Calculation

L

Lorraine Tiu

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/tutorial...24-87830ce3779f/rss--atom-feed-autodisco.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Project Server 2007 Calendar Creation 1
calculate overtime at 2 different rates 5
Need overtime formula help 5
Allocated amount rounded to nearest .25 without exceeding total 6
Need help with Overtime formula. 6
Overtime formulas 14
Overtime Calculation for Overtime 4
Variable workweek overtime 1

Top