Discussions

 View Only
  • 1.  I want to add 90 minutes to a time, for an end time.

    Posted 09-24-2018 20:18
    I am trying to get google email to recognize a calendar date so that it can be added from email like an invitation. The new gamil isn't recognizing this so I'm thinking that I need to have an end time. I'm trying to do this by adding 90 minutes from the meeting start time. 


  • 2.  RE: I want to add 90 minutes to a time, for an end time.

    Posted 09-24-2018 21:58
    Are you trying to create a formula Time Of Day field (ie just the time) or a formula date/time field? (ie the date and the time all in one field).



  • 3.  RE: I want to add 90 minutes to a time, for an end time.

    Posted 09-25-2018 13:57
    Just the time. If the meeting is set for 1:00PM then it's over at 2:30PM. Just time.


  • 4.  RE: I want to add 90 minutes to a time, for an end time.

    Posted 09-25-2018 13:59
    A field of type Time of Day formula would look like

    [My start Time field] + Minutes(90)





  • 5.  RE: I want to add 90 minutes to a time, for an end time.

    Posted 09-25-2018 15:20
    Thank you, it worked. I tried a version of that I guess I overthought that one.