DATEDIFF - HOURS AND MINUTES

[LYeo87]

Hi - What do I need to change to get an output of both the relevant hours and mins?

2b MINS) Scheduled Duration Hours = DATEDIFF([LOG Booking Start Time (Changed To)],[LOG Booking End Time (Changed To)],MINUTE)

[V-pazhen-msft · Accepted solution]

@LYeo87 

You could use format to convert the integer to "hh:mm:ss" or "hh:mm".

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@LYeo87 ,

This will give you duration

[LOG Booking Start Time (Changed To)] - [LOG Booking End Time (Changed To)]

or divide by 60

2b MINS) Scheduled Duration Hours = DATEDIFF([LOG Booking Start Time (Changed To)],[LOG Booking End Time (Changed To)],MINUTE)/60

or convert it like hh:mm 

refer: https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-usi...