Help

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

Topic Labels: Formulas
Solved
Jump to Solution
1723 4
cancel
Showing results for 
Search instead for 
Did you mean: 
davidcarldesign
6 - Interface Innovator
6 - Interface Innovator

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

4 Replies 4
davidcarldesign
6 - Interface Innovator
6 - Interface Innovator

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’)

jmoore
4 - Data Explorer
4 - Data Explorer

@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.

Screen Shot 2023-08-31 at 8.07.28 AM.pngScreen Shot 2023-08-31 at 8.05.46 AM.pngThanks! 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 ( ' )