0
Duration( Appointment ) = End( Appointment ) – Start( Appointment ) result in hours only ( hh:mm ) not days (dd:hh)
Hi there, i am using " Duration( Appointment ) = End( Appointment ) – Start( Appointment )" formula, and the result is displayed in days and hours. Isn`t there an option so i can display the result in hours? When creating the formula i have selected the number format and assigned a private unit measure but its not keeping it. Thank you!
1 reply
-
This formula gives the duration of an appointment in (fractional) hours. The magic number is the number of milleseconds in one hour:
number(duration(Appointment)) / 3600000
Content aside
- 3 yrs agoLast active
- 1Replies
- 349Views