change the time in the date type field

[Afreyik]

Hello
can you please tell me how to automatically change the time in the date type field, or enter the time I already need?

[Afreyik]

I tried to change it using a formula - it does not work, since it is necessary that the date field remains a field type - date

[Sho]

How about the Duration field?
Its content is a number in seconds.

 

[Sho]

The formula field could also be formatted to look like Duration.

Duration Field Type - Overview | Airtable Support

[Afreyik]

Гарна ідея, я спробую пізніше, дякую