Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys
I need a little help from you
I have a column in my table that displays minutes and i need to convert them into duration, for example 90 minutes should be turned into 1 hour and 30 minutes (1:30).
How can i do it?
Thank you
Try this
Floor(90/60)&':'&mod(90,60)
Hi,
Suppose your field is called minutes
you can try this:
=Time(Time#(minutes,'mm'),'hh:mm')
Hi,
You can use below expression:
=interval(90/1440,'hh:mm')
Thanks