Forum Discussion
22:00 Hour Time display difference
I have come across an issue with a formula that I am working on. In the first cell I input my time in 24 Hour format I.E. 21:30 and in the second cell it will display (07:30) 10 Hours later and any t...
Which formula do you use to calculate time in the second cell?
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?