Is there anyway to show the hours and minutes of an appointment on the calendar?

rslackrslack ✭✭✭✭
edited February 5, 2020 in Questions
We were having an issue with conference rooms or vehicles being overbooked because we did not have the duration of the appointment listed on the calendar.  The calendar does have a duration in minutes that just lists total minutes but it did not look as nice as having 1 hours 35 minutes.  etc.  So what is the best way to convert Duration in Minutes (a standard field) into hours and minutes.

Comments

  • rslackrslack ✭✭✭✭
    edited February 5, 2020
    This formula works well to convert Duration in Minutes to an hours and minutes format.  If DurationinMinutes is less than 60 it just shows (assuming it is 30 minutes) "30 Minutes".  It leaves the Hours off.  If it is greater than 60, for example 215 minutes it would convert it to "3 hour(s) 35 Minutes".  You could change this to be Days, Hours, and Minutes but multiple day appointments are rare so I am stopping at Hours and Minutes. If it were multiple days it would just list it as hours "36 Hour(s) 30 Minutes".

    I just created this formula field on the Event.  Hope it helps someone someday. 

    IF(DurationInMinutes<60, 
    Text(DurationInMinutes) & " Minutes", 
    IF(Floor((DurationInMinutes)/60)-(DurationInMinutes/60)=0,Text(DurationInMinutes/60) & " Hour(s)", 
    Text(Floor(DurationInMinutes/60)) & " Hours " & Text(Round((((DurationInMinutes/60)-(Floor(DurationInMinutes/60)))*60),0))&" Minutes"))
  • Karen WaldschmittKaren Waldschmitt 🛠️ 
    edited March 2, 2017
    Rich~

    Thanks for sharing the solution! Glad you were able to answer your own question, love it when that happens :)

    Karen
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!