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 have 2 associates in the process, my hourly processing average is 55 items, so my throughput is 110. It takes 1.82 hours to complete that.....my issues is how do I display my expected completion time? I want to take the current time and add 1.82 hours...but can't figure that part out. The answer should be 3:22 PM if it's 1:00 and I add 1.82 hours. Thanks in advance!!!
2 Replies
- 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.
