I composed the next Worksheet in order to count my Workhours.
Other solutions proposed over the internet would not work, since the Workhours amount per day was not fixed at first. The problem makes its appearrance sometimes when the "Total Work Hours" equal the "Normal Work Hours". When i try to format the Super Hours Cells using conditions, i don't get the correct result. The equality seems not to be the case.
Cell K9: Negative or very big date and time values are displayed as pound signs (###)
The following information are important:
- The Cells A4:B500, F4, F5 are formated like: Hour 13:30
- The Cells J7:R9 are formated like: Custom [h]:mm
- J7: =SUM($C4:$C34) and respectively Cells K7,L7...
- J8: =J4*$F$5 and respectively Cells K8,L8...
- J9: =IF(J$7>=J$8;J$7-J$8;J$8-J$7) and respectively Cells K9,L9...
I would like to know why this happens and if there is a solution or a different approach.
See Question&Answers more detail:os