Forum Replies Created

Viewing post 1 (of 2 total)

  • RE: convert decimal to time HH:MM:SS

    GOT IT!

    =Floor(Fields!Time.Value*3600 / 3600) & ":"& RIGHT("0" &Floor(Fields!Time.Value *3600/ 60) - Floor(Fields!Time.Value*3600 / 3600) * 60, 2) & ":"& RIGHT("0" & Fields!Time.Value*3600 - Floor(Fields!Time.Value*3600 / 60) * 60, 2)

    and this...

Viewing post 1 (of 2 total)