| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
Try:
=SUM(E1:E2-D1:D2,-(E9:E11-D9:D11),--(E1:E2<D1:D2),-- (E9:E11<D9:D11)) Array-entered (press ctrl + shift + enter). This gives you total run time for the 2 main runs (D1 to E1 and D2 to E2) minus any machine downtime. Format the formula cell as time. HTH Jason Atlanta, GA -----Original Message----- I wish to calculate the time the machine has actually run. D1 = 22:00 (Start Time) F1= Time Run E1 = 00:15 (Finish Time) D2 = 00:15 (Start) F2= Time Run E2 = 02:30 (Finish) D9 = 22:20 (Breakdown) E9 = 22:30 (Restart) D10 = 23:15 (Breakdown) E10 = 23:30 (Restart) D11 = 00:30 (Breakdown) E11 = 02:00 (Restart) Is there a formula that can scan a range (D9:E11) and give me tha answer in F1 of the time run between the Start & Finish times any help would be appreciated Pete . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing Time Data | Excel Discussion (Misc queries) | |||
| Summing Time | Excel Discussion (Misc queries) | |||
| entering numbers to display a time format | Excel Discussion (Misc queries) | |||
| Help - Information with time and date | Excel Discussion (Misc queries) | |||
| time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
Threaded Mode
