Time issues

[Grymm]

Hello I have a question I'm having problems finding a solution for.
I have a time sheet which someone would complete as 07:00 in, 12:00 out for lunch, 13:00 Back from Lunch, 17:00 finish.
What Im trying to do is to break down what the person has put in so it shows at what points during the day they are in on an hourly breakdown sheet, as in they are in at 07:00, in at 08:00 etc but out at 12:00, in at 13:00, in at 14:00 etc
Ive looked all over but to be honest Ive been having problems trying to describe what I'm after when I'm putting it into a search engine.
Can anyone help with this please

Thanks in advance

 

[mole999]

give them four columns
start break start break finish finish, then you work the hours between start and finish and extract the break start finish

]
]]