Trying to create a date and time graph

Hi there

I am trying to create a chart such as below to show the hours worked each day

2018-09-18_15-36-37.jpg

Can anyone help

It looks like you want an in cell charting technique using conditional formatting. I expect you will use some kind of formula for the conditional formatting (https://support.office.com/en-us/art...b-f1951ff89d7f ) where the formula looks for "time in 'hour of day' column is between in and out times for day in 'date' row". Your screenshots give no information about where or how all that information is stored, so I cannot make specific recommendations, but that should give you a place to start.