Forum Discussion
jonathonsalt010
Oct 14, 2019Copper Contributor
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...
SergeiBaklan
Oct 14, 2019Diamond Contributor
Which formula do you use to calculate time in the second cell?
jonathonsalt010
Oct 14, 2019Copper Contributor
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
- SergeiBaklanOct 14, 2019Diamond Contributor
Better to append the file to the post. However, if it's with sensitive information send me a private message.
- jonathonsalt010Oct 15, 2019Copper Contributor
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
- jonathonsalt010Oct 16, 2019Copper ContributorAny thoughts what might be the cause of the issue?