Forum Discussion
Helper IIDATEDIFF - HOURS AND MINUTES
Hi - What do I need to change to get an output of both the relevant hours and mins?
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.
2 Replies
- amitchandak
Super User
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
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.
