Hi,
I use an excel sheet whereby time charged to projects in decimal format (i.e 2.0 hours) is compared to time actually worked during the day (based on start and end times) in HH:MM format. This formula works 99.9% of the time but I have noticed an issue with times in general when the value is greater than 12 hours (12:00).
So, for example if I input 2.0 hours to the sheet in decimal format against a project and then enter a start time of 11:00 and an end time of 13:00 for 2:00 hours total time this returns an actual figure of 0.083333333333333300000 which then compares to the total hours worked of 2 hours (2 hours/24 hours to get the decimal) = 0.0833333333333333000
However, if I change the start and end times to 12:00 and 14:00 (which I believe should give exactly the same answer) this does not work as this returns an actual figure of 0.083333333333333400000 which then makes it appear that I have not charged the correct amount of time?
Can anyone explain why this is and if there is anyway around it please?
The sheet I have is set up to highlight if the time charged does not match the actual hours input which in the second example above it looks like it doesn't but in actual fact it does. As I say the issue seems to crop up where the time 12:00 is involved.
Thanks,
Mark
Bookmarks