Hi, my maiden post on the board! Although I imagine I'll be here quite a lot from now on!
I'm trying to set up a time sheet that will calculate the remaining time by summing two collums and subtracting them from each other. The formula I'm using looks like this:
I know it's a long formula, but it's imperative that the whole calculation is done in one cell! This formula uses the cell above to create a running total down in one column including new numbers from the columns to the left.
The formula works well...until it reaches the number four, at which point instead of adding the hour onto the total and resetting the decimal to 0, it keeps the decimal as 60 and doesn't add it on as it was for 3 and below. As far as I can see the formula is exactly the same in each cell and I've got absolutely no idea how it's happening.
Has anyone encountered this before, or does anybody know of a fix? The only workaround I can think of is an IF that checks for the 0.6 and converts it to a 1, but I think I'll run out of characters trying that!
Thanks in advance for any help
Bookmarks