| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find number of hours past a spesific time
Im pretty new to excel. At least with other things than the regular - + * and /. I have a huge problem getting the hours past 12:00 o'clock when I have a field with start and stop time. For instance 8:00 (A1) to 16:00 (A2). I should get 4 hours. As to the 16:00, I use 24 hour format. I have tried with plenty of IF statements but to little help. It just don't seem to work with hours. Only with numbers, text and so on. Maby it's the : it's not cooperating with. I'm not sure. I want to calculate my overtime. Past 12:00 is 50% on saturdays. What are my options? -- MrHaugen ------------------------------------------------------------------------ MrHaugen's Profile: http://www.excelforum.com/member.php...o&userid=36191 View this thread: http://www.excelforum.com/showthread...hreadid=559802 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to find number of hours past a spesific time
=(A2*24)-12 will give overtime hours (format cell as general)
Or =Max(0,(A2*24-12 )) if there could be no overtime HTH "MrHaugen" wrote: Im pretty new to excel. At least with other things than the regular - + * and /. I have a huge problem getting the hours past 12:00 o'clock when I have a field with start and stop time. For instance 8:00 (A1) to 16:00 (A2). I should get 4 hours. As to the 16:00, I use 24 hour format. I have tried with plenty of IF statements but to little help. It just don't seem to work with hours. Only with numbers, text and so on. Maby it's the : it's not cooperating with. I'm not sure. I want to calculate my overtime. Past 12:00 is 50% on saturdays. What are my options? -- MrHaugen ------------------------------------------------------------------------ MrHaugen's Profile: http://www.excelforum.com/member.php...o&userid=36191 View this thread: http://www.excelforum.com/showthread...hreadid=559802 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert a number to a time | Excel Discussion (Misc queries) | |||
| Time format to number while keeping value | Excel Worksheet Functions | |||
| how to calulate time in hours cbetween two different dates? | Excel Worksheet Functions | |||
| Calculate difference in time spanning a day, during office hours o | Excel Discussion (Misc queries) | |||
| Time functions, how do I work out number of hours | Excel Worksheet Functions | |||
Linear Mode
