Working hours in a graph

[erjon]

Hello there,

How do I need to represent hours worked daily in a graph? Example: On Monday I started work at 7am-5pm. On Tuesday 7:30am-5:30om. How do I make it look on a chart that I started at a certain time and finished 8 hours later? The axis should have time range 5am-9pm.

Thank you

[Herbds7]

Excel 2010 with PowerPivot Add-In.
Compatible with Office 2013 Pro Plus.
http://www.mediafire.com/view/l78rt3.../05_20_14.xlsm
Edit to suit.
Easier solution: Use MS Project.

[erjon]

Thank you, appreciate it.