Post reply

convert decimal to time HH:MM:SS

  • July 19, 2010 at 10:15 am

    #1194988

    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 is for the sum

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

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply