We use a Dashboard to show what each employee is working on. Most importantly it tells us the time the employee clocked into that operation, how many actual hours are on that job at that time, the estimated hours it will take, a calculated field taking estimated hours minus actual hours, and the current time the dashboard refreshed. We would love to have actual hours be a calculation of the actual hours on that job plus the value of the current time minus clock in time. The dashboard refreshes every minute so there should be a hard value to formulate. I have attached a screen shot of our dashboard. Can anyone help?
I don’t get what your question is. You should be able to look in the laborDtl for the clock in time and subtract that from the current time. Then add that to you previous totals. You laid it out pretty well, but you didn’t say why it doesn’t work.