Announcements
removed
First, convert text to datetime using custom format h:mm; this will be a datetime variable
then using the variable you just made, convert datetime to text using custom format hh:mm
You can't convert directly from text format to custom date format.
If you get data from excel and it is returned as text, then you convert that to date format, after that you can convert that date format to custom text format hh:mm.
Regards,
Kresimir
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
David_MA 262 Super User 2026 Season 1
11manish 167
Haque 154
