|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
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
.
|