Hi all,
I am trying work out if it's possible to calculate the 'processing time' we perform during our work day which is 12 hours.
Currently I have questions set up like this:
START_TIME (datetime)
FINISH_TIME (datetime)
DOWNTIME_HRS (decimal)
RUNTIME_HRS (decimal)
The current calculation i have set up is this:
RUNTIME_HRS = int(${FINISH_TIME} - ${START_TIME}) div (1000*60*60) - ${DOWNTIME_HRS}
This works on a 24 hour clock, but doesn't give a true indication of the runtime of the processing as it only operates for 12 hours. So I get incorrect answers if the processing is over 2 days.
For instance, if we are half-way thru processing we will stop at the end of the work day (12 hours), then re-start the next day.
Any idea how I could capture this in the calculation?
Basically looking for a 12 hour day rather than 24 hours.
thanks