Adding duration time.

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
How do I add 1 hour to the time of a meeting. So if the meeting starts at 1:00PM then it will end at 2:00PM. I am trying to create a field so I can try and get Ical to work.
Photo of Cassie

Cassie

  • 182 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Chuck Grigsby

Chuck Grigsby

  • 1,978 Points 1k badge 2x thumb
[Start Date] + Hours(1)
Not tested but something like that
https://login.quickbase.com/db/6ewwzuuj?a=dr&rid=66&rl=cyq
Photo of Cassie

Cassie

  • 182 Points 100 badge 2x thumb
When I do that it brings my meeting end time to 840. I changed the formula from minutes (60) and I have done hours the same way (1) and I get these strange numbers.
Photo of Chuck Grigsby

Chuck Grigsby

  • 1,978 Points 1k badge 2x thumb
Oh make sure you're field is a Date/Time field and not just a date field.