| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to get exact hours above a spesific time?
I have a problem getting the hours I work overtime to be calculated. I have a field with start time (A1) and end time (A2). On saturdays I get 50% overtime paymant after 12:00 o'clock. Want to calculate the hours past 12:00. I have tried with things like IF(A212:00;"A3=A2-12:00;0;). I just CAN'T get it to work with the hour format. ONLY with numbers and text. Is this impossible with the xx:xx format? What could be done? (PS. I know there might be errors in my example above. Just don't have the excel here to test it at this time.) -- MrHaugen ------------------------------------------------------------------------ MrHaugen's Profile: http://www.excelforum.com/member.php...o&userid=36191 View this thread: http://www.excelforum.com/showthread...hreadid=559904 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to get exact hours above a spesific time?
In A3
=IF(A2TIME(12,0,0);A2-.5;A2) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "MrHaugen" wrote in message ... I have a problem getting the hours I work overtime to be calculated. I have a field with start time (A1) and end time (A2). On saturdays I get 50% overtime paymant after 12:00 o'clock. Want to calculate the hours past 12:00. I have tried with things like IF(A212:00;"A3=A2-12:00;0;). I just CAN'T get it to work with the hour format. ONLY with numbers and text. Is this impossible with the xx:xx format? What could be done? (PS. I know there might be errors in my example above. Just don't have the excel here to test it at this time.) -- MrHaugen ------------------------------------------------------------------------ MrHaugen's Profile: http://www.excelforum.com/member.php...o&userid=36191 View this thread: http://www.excelforum.com/showthread...hreadid=559904 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to get exact hours above a spesific time?
Thanks alot. The TIME function worked like a charm! -- MrHaugen ------------------------------------------------------------------------ MrHaugen's Profile: http://www.excelforum.com/member.php...o&userid=36191 View this thread: http://www.excelforum.com/showthread...hreadid=559904 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting a decimal time into hours and minutes | Excel Worksheet Functions | |||
| template or formula for start time -finish time -total hours ple | New Users to Excel | |||
| Time sheets | Excel Worksheet Functions | |||
| calculate difference in time to hours | Excel Worksheet Functions | |||
| time format multiplied by hours worked ? | Excel Worksheet Functions | |||
Linear Mode
