Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello
i have an issue
i have the following time of reception in minutes:
I want to convert it into hh:mm:ss
Any ideas ?
Thanks
Divide the number of minutes by 1440 (number of minutes in a day) and then format as time or timestamp, e.g.
Timestamp(Temps_reception/1440,'hh:mm:ss')
Divide the number of minutes by 1440 (number of minutes in a day) and then format as time or timestamp, e.g.
Timestamp(Temps_reception/1440,'hh:mm:ss')
Use the Interval() function as below
in load script
Interval( Temps_reception,'hh:mm:ss') as Temps_reception