Reply
Sat 10 Mar, 2007 12:04 am
Okay folks - I am asking for help because someone asked me for help earlier at work- and with limited time - I could not figure it out.
Okay - so picture a factory - say your making widgets
you start production at 2PM
You have various downtime that formulates to 7.2 hours worth of downtime and production say 6.5 hours production, 1.2 downtime.
What is the final finish time?
How do you get it to take you sum mated production time - and add it to original start time to come up with an "actual" finish time?
The problem I have is when you time stamp the "start time" it is not in the same format as "production time" -
Obviously any moron can figure out - we started at 2 PM, plus 7.2 hours equals 9:12 as your finish time - but how do you formulate it?
_________________
You'll need to create a formula to convert decimal hours to hours and minutes, then add the converted cells to your start time.
7.5 hours = 7:30:00
7.5 won't add to a time-formatted cell, but 7:30:00 will add correctly.
Stumble It!
Tweet This
Bookmark on Delicious
Share on Facebook
Share on MySpace