Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a field with the time stored as 800 for 08:00 how do I change the time format to get the time to display as 08:00
The field is saved as a number format
Hi,
try with
Time(Time#(Right(0 & Field,4), 'hhmm'),'hh:mm')
Thank you worked like a charm 😁