| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Overtime Calculation | Excel Discussion (Misc queries) | |||
| Overtime Calculation for Overtime | Excel Worksheet Functions | |||
| overtime calculation | Excel Discussion (Misc queries) | |||
| Overtime Calculation | Excel Discussion (Misc queries) | |||
| overtime calculation | Excel Worksheet Functions | |||
Hybrid Mode
