>Hi,
>
>I've got a function that displays seconds in the format HH:MM:SS.
>
>In calculating the seconds part of the string, I do this:
>
>
>INT(m.tnElapsedSeconds % 60)
>
>
>When m.tnElapsedSeconds = 71 I get 10 being returned, but only when the function is called in a report!
>
>Anybody have any idea what could be causing this?
are you sure is it 71 ?.
try
? (m.tnElapsedSeconds - 71)*1E18
YOU CAN TRY
INT(m.tnElapsedSeconds) % 60
REOUND(m.tnElapsedSeconds,0) % 60
but for some m.tnElapsedSeconds INT() and ROUND() fails.