TimeDiff calculations inside Query.

[cap.zadi]

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

[rpeare]

if you want it to be displayed as 90 (minutes) use

datediff("n", StopTime, RestartTime)

If you want it to be displayed as 1.5 (hours) use

datediff("n", StopTime, RestartTime)/60

assuming of course your stop time and restart time are both stored as date/time fields.