Convert minutes into time.

[#1]

Hi everyone,

suppose

I have a field name minutes or variable $(minutes).

I am looking to convert into time. (format hh:mm:ss.)

let me know~ master~

[MarcoWedel · Accepted solution]

Time( $(minutes)/(60*24), 'hh:mm:ss')

[anbu1984]

=Time(Time#(Minutes,'mm'))

[Anonymous]

Or

time(time#($(minutes),'mm'), 'hh:mm:ss')

[jagan]

Hi,

Try like this

=Time(Time#(variableName,'mm'), 'hh:mm:ss')

or

=Time(Time#(FileldName,'mm'), 'hh:mm:ss')

Regards,

Jagan.

[chriscammers]

Also try

=Interval($(vMinutes)/(60*24),'d hh:mm')

This will give you a number of days, hours and minutes.

[#7]

time#(variablename,hh:mm:ss)