Dealing with Time

wammmy

New Member
Joined
Dec 22, 2006
Messages
27
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
JKLM
9
10CELL 1CELL 2CELL 3
11
12Start4:23 PM4:30 PM4:38 PM
13Stop12:00 AM12:00 AM12:00 AM
14Start12:05 AM12:05 AM12:05 AM
15Stop12:37 AM12:37 AM12:37 AM
16Start
17Stop
18Start
19Stop
20Start
21Stop
22Start
23Stop
24Start
25Stop
26Start
27Stop
28
29END12:12 AM12:21 AM12:29 AM
30
31HRS0:000:000:00
32MIN000
Job Data
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

wammmy

New Member
Joined
Dec 22, 2006
Messages
27
Ok I had thought it was going to be something like that but how would I incorperate that into the formula.
 

daniels012

Well-known Member
Joined
Jan 13, 2005
Messages
5,219
well, include the date in with the time on your spreadsheet and see if the results happen.
Michael
 

wammmy

New Member
Joined
Dec 22, 2006
Messages
27
would it be easier to use military time? If it would then I would just have to get used to using that.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,951
Messages
5,834,538
Members
430,295
Latest member
amdis

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top