I just ran a quick test, and formulas work fine with the new timeline view. One critical point to remember about this new view is that the start and end fields need to have the same options in their settings (e.g. time vs no time, GMT vs not GMT). As long as they’re both configured the same way, it should work.

Re: the 5 pm default, are you saying that you’d like the ability to override that time in certain cases, or do you always want it 5 pm no matter what?

Sorry I know this is an old thread, but I am having this same issue and have not found a solution. I would like to be able to set it so that when someone enters date, the time in that field defaults to 5pm, but then someone can manually change it to something else if they want to. Currently, if you enter a date, the time defaults to midnight unless it's manually changed. Do you know how to do this?

This is a feature that would likely help me a lot. 

I have to enter several date and time of past events. Most of these events happen between 10am-4pm, but after typing the day (e.g. ‘26’) and then ‘Tab’, Airtable then makes me scroll down from the midnight 0:00 all the way down to the time that always hovers around 1pm. 

This feature is sort of implemented in the case above when the day happens to be today. For instance, if the event I’m entering happened today and it’s 2pm right now, then the default time will be 2pm. 

Since I enter date/time of past events that happen during office hours, and I work during office hours, the overlap is convenient, but If I enter date/times of current-day events at 11pm of the same day, then the default time of 11pm will force me to scroll up to whatever event I’m recording, e.g. at 9am, “far” from 11pm at the scroll-down/up point of view.

If we were able to just set a default time like in my case 1pm would be great, and would be better than the particular default behavior of today’s “right now” times as well.

Try using an automation for this?

The automation triggers whenever a record’s created and pastes the value from ‘Calculation’ into ‘Date’ and I’ve set it up here for you to check out

DATEADD(
  DATETIME_PARSE(
    DATETIME_FORMAT(
      Date, 'DD MMM YY'
    ),
    'DD MMM YY'
  ),
  9,
  'hours'
)

Hey ​@mobile_pilot,

​@TheTimeSavingCo solution will def work, and is the easiest/no-code approach. However, if you have a paid Airtable plan I would probably suggest to have an automation which will include a script output the default time and then use an update record action block to stamp it. In this way, you would avoid having “helper” fields which at the end of the day make your base dirty and messy!

Please let me know if you need any help setting this up. I’d be happy to help.

Mike, Consultant @ Automatic Nation