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...
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/1440
Next date will be
=A7+F7
and the time is just
=F7
Only apply proper date and time formats to these cells. Please see in columns P and R in attached.
SergeiBaklan I appreciate the help, after looking at it the first time I thought it looked overly complicated for no reason. I just couldn't think of how to fix it. thank you.