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

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • Answered
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. 
Photo of Cassie

Cassie

  • 182 Points 100 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
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).

Photo of Cassie

Cassie

  • 182 Points 100 badge 2x thumb
Just the time. If the meeting is set for 1:00PM then it's over at 2:30PM. Just time.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
A field of type Time of Day formula would look like

[My start Time field] + Minutes(90)



Photo of Cassie

Cassie

  • 182 Points 100 badge 2x thumb
Thank you, it worked. I tried a version of that I guess I overthought that one.