Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

What's the formula to get time (only in hrs and mins) from Date/Time field

Topic Labels: Formulas
Jump to Solution
570 2
Showing results for 
Search instead for 
Did you mean: 

What is the formula to get the Time in hours and mins from a Date/time field??

My date/time field is called “Start”.

1 Solution

Accepted Solutions

I got the answer! = DATETIME_FORMAT(Start, ‘h:mm’)

See Solution in Thread

2 Replies 2

This formula only copies the current date/time field, but I want to remove the date part:


getting close but not quite there.

I got the answer! = DATETIME_FORMAT(Start, ‘h:mm’)