Dealing with Time

[wammmy]

I had someone help me do the formula in cells K31-M31 and the formula works great for one shift. I now have 3 shifts and the formula will not do the job around the clock. Basically K31-M31 stay 0.00 and the formula does the math for the last stop time entered. Can this be made to work around the clock.

BLANK PLATING LINE DATA SHEET REDO.xls
	J	K	L	M
9
10		CELL 1	CELL 2	CELL 3
11
12	Start	4:23 PM	4:30 PM	4:38 PM
13	Stop	12:00 AM	12:00 AM	12:00 AM
14	Start	12:05 AM	12:05 AM	12:05 AM
15	Stop	12:37 AM	12:37 AM	12:37 AM
16	Start
17	Stop
18	Start
19	Stop
20	Start
21	Stop
22	Start
23	Stop
24	Start
25	Stop
26	Start
27	Stop
28
29	END	12:12 AM	12:21 AM	12:29 AM
30
31	HRS	0:00	0:00	0:00
32	MIN	0	0	0
Job Data

 

[daniels012]

It can if you include the date. This would be the only way.

 

[daniels012]

Also, here is a nice site to give you some ideas of functions to use in dealing with time that goes into the next day.
http://www.cpearson.com/excel/DateTimeWS.htm
Michael

 

[wammmy]

Ok I had thought it was going to be something like that but how would I incorperate that into the formula.

 

[daniels012]

well, include the date in with the time on your spreadsheet and see if the results happen.
Michael

 

[wammmy]

would it be easier to use military time? If it would then I would just have to get used to using that.