Why does it not add up properly?

[Crackerdaq]

Hi Please see attached timesheet that I have adapted for use at work.

My issue is that cell I8 should should show as 5.00 but shows as 5.60 and K8 should show as 9.00 but shows as 9.60. Weirdly only seems to be if I enter times as pm and on the half hour as can be seen from the other sample data I have put in.

The sheet sorts itself out and does actually display the correct info at the end of it but this is really annoying me!


Can anyone help?

Cheers, Crackerdaq

[Norie]

Why should it be 5.00?

(INT(I38/60))+(MOD(I38,60))/100 evaluates to 5.6 (well actually 5.59999999).

What is it supposed to be calculating?

[Crackerdaq]

It is supposed to return the hours worked in G and H for I8 and the daily total in K8. It does this in row 7 and 9 successfully .

[Andy Pope]

Why don't you enter real time values?

[Norie]

Can't you just subtract G from H?

[Crackerdaq]

If I just subtract, then it wont take into account any of the drop down reasons in Column O. Also gives me issues with positive/negative numbers.

I realise that the way it has been set up may not be the simplest way of doing it but aside from the error above - it does work so was hoping to tweak that as opposed to re-do the whole thing.

Thanks

[Marcol]

... it does work so was hoping to tweak that as opposed to re-do the whole thing
Thanks

Old saying "You can't flog a dead horse", except perhaps to "Findus"

[Harribone]

Becuase you are using decimal numbers instead of times you will need to enter the below in I6:

Please Login or Register  to view this content.

Then drag down.

In F6:

Please Login or Register  to view this content.

And again drag down. This will account for any half hour times enter in the morning.


It would be easier to just set the cell to a time and subtract one from the other though.