LinkBack URL
About LinkBacks
Hope someone can help me with this; I've searched as best I can but its hard to even describe the problem.
I have this awful timesheet that I have to use at work. (attached = timesheet_template)
We use Excel 2003 SP3
I noticed that occasionally it would be given valid start and end times, but would output 00:00 hours worked at the end. I narrowed this down slightly; it only happened when the time worked was 7:30 hours, and only for certain start-finish times that = 7:30 hours worked.
The attached timesheet has some example start-end times that all work except for the 09:00 - 16:30 one.
To make this worse, my colleague who is apparently using the same sheet does NOT get this problem.. so I'm hoping someone can help me track down what the problem here might be.
After some exploring of the cells, I found that the calculations in column H (used to calculate the difference between hours actually worked and the standard 7:30 expected per day) would occasionally have a tiny decimal value rather than 0. (I just changed the formatting to 'number' and increased the decimals to 20 to see these). This would only happen when the time worked was 7:30 AND only with certain start/finish times!
If I'm understanding the formulas properly then whenever someone works exactly 7:30, then the timesheet should always be wrong and display 0 working hours. The only reason this doesn't always happen is due to these inexplicable decimals that mean the test for <>0 is triggered inadvertently!
Basically, can someone shed any light on why this is happening? Is this a known issue? is this an Excel 2003 issue? Does my copy of excel have some strange setting change that might explain these inconsistent calculations? this problem really got under my skin.. I hate not understanding why its breaking!
I have so far tried checking the formats for these cells, checking the calculations as best I can, I've tried adjusting the 1904 date calculations setting but nothing has improved.
Register To Reply
Bookmarks