Forum Discussion
CLAKES
Sep 15, 2021Copper Contributor
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...
mtarler
Sep 15, 2021Silver Contributor
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.
- CLAKESSep 15, 2021Copper ContributorThank 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.