Forum Discussion
Solved
Remove Date data from date time field
How do you remove date data from a date/time field so that all you have is the time data?
PatSpillane Like this:
To go from 3/25/25 7:00 pm to 7:00 pm you can use the same trick as explained above, provided that the first part is a real date, and format the cell with the result as time If it's a text it will not work. The picture below demonstrates the 2nd part of your question.