Forum Discussion

CassieHubble's avatar
CassieHubble
Qrew Cadet
6 years ago

I want to add 90 minutes to a time, for an end time.

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. 
Formulas and functions

4 Replies

Sort By
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    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).

  • CassieHubble's avatar
    CassieHubble
    Qrew Cadet
    6 years ago
    Just the time. If the meeting is set for 1:00PM then it's over at 2:30PM. Just time.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    A field of type Time of Day formula would look like

    [My start Time field] + Minutes(90)



  • CassieHubble's avatar
    CassieHubble
    Qrew Cadet
    6 years ago
    Thank you, it worked. I tried a version of that I guess I overthought that one.