Help

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

Topic Labels: Formulas
Solved
Jump to Solution
726 2
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

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