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
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,083
Messages
5,599,643
Members
414,326
Latest member
kfg1287

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