In your first response you say that I have to put two dimensions: EmployeeID and Date.
In what way can I get the "Date" dimension? Only I have timestamps.
Take out the drop table.
It shouldn't happen, but sounds like the two tables are auto concatenating.
I had to do something similar in one of my projects for a help ticket tracker.
In your scenario, you could just replace the 'created' field value with your 'Clock-in' value and the 'resolved' field value with your 'clock-out' value. I would imagine similar results.
Resolution Time expression is:
where the variable is defined as:
(resolved - created) *86400