undefined

[anlu20]

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 time" to the format of the column "response time".

Example:  2,50 must be converted to 02:30:00

Thank you.

[Greg_Deckler · Accepted solution]

@anlu20 Maybe:

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