HH:MM:SS Format

In MS reporting, how would I convert seconds into HH:MMS format?

Hello,

Try this as the expression for your textbox:

=Floor(Fields!TotalSeconds.Value / 3600) & ":"

& Floor(Fields!TotalSeconds.Value / 60) - Floor(Fields!TotalSeconds.Value / 3600) * 60 & ":"

& Fields!TotalSeconds.Value - Floor(Fields!TotalSeconds.Value / 60) * 60

Hope this helps.

Jarret

|||

Since you get to use VB in reports, try the following:

Code Snippet

Format$(Timeserial(0, 0, seconds), "hh:mm:ss")

Larry

|||Thanks Larry, this worked!|||This method worked also. Thanks Jarret.