|
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 . |
| All times are GMT +1. The time now is 06:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com