Skip to main content

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



My date/time field is called “Start”.

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



DATETIME_PARSE(Start, ‘HH:mm’)



getting close but not quite there.


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



DATETIME_PARSE(Start, ‘HH:mm’)



getting close but not quite there.


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


@davidcarldesign 

I'm having trouble getting this formula to work. Can you help me out? I'm simply trying to pull the time only out of a Date & Time field. I've played around with various date format and am consistently getting an error message. See screenshots.

Thanks! I'm new to Airtable, so please forgive me in advance if this I'm doing something dumb. 


@davidcarldesign 

I'm having trouble getting this formula to work. Can you help me out? I'm simply trying to pull the time only out of a Date & Time field. I've played around with various date format and am consistently getting an error message. See screenshots.

Thanks! I'm new to Airtable, so please forgive me in advance if this I'm doing something dumb. 


Hi @jmoore , you simply replace the apostrophes (‘) in ‘h:mm‘ with the correct quotation marks ( ' )


Reply