datediff wrong values

[spleewars]

in the query i got "in" and "out" and both are short time values



i wrote this formula to calculate the time between IN and OUT:

total: ROUND(datediff("n",[in],[out]/60,2)

but the values are not resolving right: eg: between 20:07 and 20:28 is giving me 0.35...

what is wrong?

[pbaldy]

Why are you dividing the out time by 60?

[spleewars]

actually i forgot to put a bracket: actually its -

total: ROUND(datediff("n",[in],[out])/60,2)

... and still resolving wrong

[pbaldy]

Why are you dividing by 60 at all? 21 minutes divided by 60 is .35, so you're getting an accurate answer.

[spleewars]

i am dividing by 60 to have a total hours/minutes without exceeding '60'... any better suggestion?

[pbaldy]

Is the Mod function what you're looking for?

[pbaldy]

Apparently it was, given your new thread, so I'll mark this one solved.