Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
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
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
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Perfect thank you very much for your collaboration
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |