Hey there,
I am looking to find out the right way to calculate the timediff among two fields in a query.
Machines TimeStop TimeRestart
This is the formula which i applied
DownTime: Round(([RestartTime]-[StopTime])*24,2)
It works fine but the problem is it took the calculation of minutes upto 99 and then convert to 1Hour.
so please advise how to do this?
thanks
zee