Home |
Search |
Today's Posts |
#11
![]() |
|||
|
|||
![]()
Hi Jon
Thank you very much for your help. and YES, Excel can give you just a bit of headache (my boss can't understand what can be so complicate in calculating the difference between hours!!!) So what i've done may be not very clever and smart, but i made another column for "undertime" and used formula =IF(D13$B$11,0,B11-$D$13) (so used your formula other way round ) seems to be it is working. Thank you very much! Svetlana |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
California Overtime Calculation | Excel Worksheet Functions | |||
overtime templates | Excel Worksheet Functions | |||
how do i make overtime in my payroll sheet calculate after 42.5 h. | Excel Worksheet Functions | |||
How can I calculate Vacation Time earned based on length of emplo. | Excel Discussion (Misc queries) | |||
calculate difference in time to hours | Excel Worksheet Functions |