Graphing how long it takes to complete a job by the amount of time it takes to perfrom each task

ddram21

New Member
Joined
Jul 16, 2014
Messages
1
I am trying to figure out which graph should be used to best represent how long it takes to complete a job with a breakdown of how long each task takes by using the start times from each task to get the time intervas. This will actually be done over multiple stataions.

record task1 task2 task3 task4 task5 task6 task7
1 10:00:00 10:08:00 10:10:00 10:10:45 10:11:00 10:12:22 10:20:16
2 11:05:14 11:15:04 11:17:45 11:18:35 11:18:55 11:20:00 11:28:36
3
4
5

So I have the time it takes to complete each task by subtracting the the start time of the next task from the previous one (task2-task1 = time it takes to complete task 1; task3-task2 = time it takes to complete task2...so on), with the exception of the last task with is the total time to complete the job (task7-task1 = total time to complete job).

When it's all said and done, I will have over 100 records and want to show a breakdown of how long it takes to complete its job based on the time intervals to complete each task. I am stumped on how to show this information for all the records I will have.

Thanks in advance for any feedback.

:confused:
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Forum statistics

Threads
1,213,539
Messages
6,114,221
Members
448,554
Latest member
Gleisner2

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