What is the formula to get the Time in hours and mins from a Date/time field??
My date/time field is called “Start”.
Solved
What's the formula to get time (only in hrs and mins) from Date/Time field
+5Best answer by davidcarldesign
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’)
+5This 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.
+5This 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’)
+2I'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.
+3I'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 ( ' )
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.