Forum Discussion
22:00 Hour Time display difference
I'm not sure to be honest. the spread sheet was created years ago and the people i now work for are saying that this has been an issue ever since it was made. if i could send you the file you can take a look. SergeiBaklan
Better to append the file to the post. However, if it's with sensitive information send me a private message.
I put the time in cell B7 and the time difference will show up in cell M7, however any time that I input will be correct even one minute before and one minute after except 22:00. With a ten hour time difference the end result should be 08:00 but it will display 09:00 instead. Have you come across this before?SergeiBaklan
- Any thoughts what might be the cause of the issue?
Sorry, I missed your previous post. The reason is in rounding errors in intermediate formulas. I don't know why so complicated calculations are used. If you need only date and time on that date, formula in F7 is enough
=B7+D7/24+E7/1440Next date will be
=A7+F7and the time is just
=F7Only apply proper date and time formats to these cells. Please see in columns P and R in attached.