Problem with function format
I have a time sheet set up to calculate how many holiday hours should be paid
for working Christmas. It is based on numbers entered in the 24 hour format. For every other day of the year i have been using "=J14-I14+(J14<I14)". This will return 24:00 instead of 00:00. I set up an if function to calculate double time based on whether or not it was a scheduled work day. =IF(O790.15,(P80-O80+(P80<O80)),(P80-O80+(P80<O80)))*2. For the schedule, 0800-2000, it should pay 24 hrs. Since there is no 24:00, i am getting the result 00:00. It totatls up correctly in the weekly total category. But payroll will have fits if they see the zero's. Can anyone help? Thanks in advance, Steve |
Hi Steve
format the cell with the custom format [hh]:mm "Steve" wrote: I have a time sheet set up to calculate how many holiday hours should be paid for working Christmas. It is based on numbers entered in the 24 hour format. For every other day of the year i have been using "=J14-I14+(J14<I14)". This will return 24:00 instead of 00:00. I set up an if function to calculate double time based on whether or not it was a scheduled work day. =IF(O790.15,(P80-O80+(P80<O80)),(P80-O80+(P80<O80)))*2. For the schedule, 0800-2000, it should pay 24 hrs. Since there is no 24:00, i am getting the result 00:00. It totatls up correctly in the weekly total category. But payroll will have fits if they see the zero's. Can anyone help? Thanks in advance, Steve |
Thanks a million Frank. It's always something simple.
"Frank Kabel" wrote: Hi Steve format the cell with the custom format [hh]:mm "Steve" wrote: I have a time sheet set up to calculate how many holiday hours should be paid for working Christmas. It is based on numbers entered in the 24 hour format. For every other day of the year i have been using "=J14-I14+(J14<I14)". This will return 24:00 instead of 00:00. I set up an if function to calculate double time based on whether or not it was a scheduled work day. =IF(O790.15,(P80-O80+(P80<O80)),(P80-O80+(P80<O80)))*2. For the schedule, 0800-2000, it should pay 24 hrs. Since there is no 24:00, i am getting the result 00:00. It totatls up correctly in the weekly total category. But payroll will have fits if they see the zero's. Can anyone help? Thanks in advance, Steve |
All times are GMT +1. The time now is 09:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com