Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with txt format | Excel Discussion (Misc queries) | |||
Format Painter button problem | Excel Discussion (Misc queries) | |||
How do I unhide the cell format function in Excel 2000 | Excel Worksheet Functions | |||
problem with formatting cell to date format | Excel Worksheet Functions | |||
cut and paste format problem | Excel Discussion (Misc queries) |