convert minutes to hours minutes and seconds

[JonathanS]

At the moment I am validating the time of use of a certain article having a start and end date, I have achieved the difference with datedif but the value is in minutes, how can I convert this into hours, minutes and seconds, thank you very much for your great

Time(Reporte([Diferencia],24),Reporte(mod([Diferencia],24),60))

Error .(

help

[v-henryk-mstf]

Hi @JonathanS ,

Whether the advice given by @Samarth_18  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Looking forward to your feedback.

Best Regards,
Henry

[Samarth_18 · Accepted solution]

Hi @JonathanS ,

Please try this:-

Duration in Hours and Minutes = 
var _Minues=[Column1]
var _Hours=int( _Minues/60)
var _RemainingMinutes=MOD(_Minues, 60)
return
  _Hours&" Hours & "& _RemainingMinutes& " Minutes"

Output:-

Thanks,

Samarth

[JonathanS]

Perfect thank you very much for your collaboration