Minute Formulas
Do you mean..
ColA ColB ColC Col D
Start Time End Time Break Total time
8:00 16:00 0:50 =B2-A2-C2
OR
ColA ColB ColC
Start Time End Time Total time
8:00 16:00 =B2-A2-TIME(0,50,0)
If this post helps click Yes
---------------
Jacob Skaria
"Angie" wrote:
I am trying to set up a spreadsheet for part numbers and how often the parts
are used according to start time and end time of the production line. I also
want the 2 breaks of 10 minutes and 1 lunch of 30 minutes included in the
formula.
Can someone please suggest a simple and effective minute formula?
--
Thank you,
Angie
|