excel chart with date, start and end times (duration)

Hi,

I have the following dataset and I would like to create a stacked bar or any other chart to display how long batch is taking on a given day. Any help will be appreciated. (PS: duration below is just an example)

Batch date start time end time duration

01/01/2016 01/01/2016 01/01/2016 09:14:11
02/01/2016 02/01/2016 02/01/2016 12:09:09
03/01/2016 03/01/2016 03/01/2016 08:31:01
04/01/2016 04/01/2016 04/01/2016 09:00:00
05/01/2016 05/01/2016 05/01/2016 08:12:11

Thanks
Rav

Nobody likes to have to type in a lot of data before being able to play about with it - attach a sample workbook (the FAQ describes how to), and you might get a speedier response.

Pete

That's not the same as attaching a workbook (and your data seems to have changed).

Pete

Thanks Pete. I have done it now. Appreciate your quick response