Forum Discussion
Need help adding hours to time format value
Hello, I'm hoping someone can help....I'm trying to predict the time in which I am complete with processing my volume for my Operations group... let's say it's 1:00 PM and my volume is 200, I hav...
if your 1:00 PM is an actual time then you add the result (1.82) divided by 24 to that initial time and make sure that cell is also formatted to show time.
Thank you! that led me to my answer. I multiply 1.82 by 24, then changed the format to time and add 1:00 to my new time. Thanks again.