Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

undefined

How can I convert decimal to duration format?   response time target response time 00:30:00 2,50 01:00:00 0,433 02:00:00 1,133   I want to convert the column "target response t...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Anonymous Maybe:

    Column = FORMAT(INT([Column1]),"00") & ":" & FORMAT(([Column1] - INT([Column1])) * 60,"00") & ":00"
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous Maybe:

Column = FORMAT(INT([Column1]),"00") & ":" & FORMAT(([Column1] - INT([Column1])) * 60,"00") & ":00"