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

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Ok I had thought it was going to be something like that but how would I incorperate that into the formula.
 
Upvote 0
well, include the date in with the time on your spreadsheet and see if the results happen.
Michael
 
Upvote 0
would it be easier to use military time? If it would then I would just have to get used to using that.
 
Upvote 0

Forum statistics

Threads
1,213,557
Messages
6,114,293
Members
448,564
Latest member
ED38

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
Back
Top