Thread: Minute Formulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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