Time format

[Eaun]

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

[StarinieriG · Accepted solution]

Hi, 

try with 

Time(Time#(Right(0 & Field,4), 'hhmm'),'hh:mm')

[Eaun]

 Thank you worked like a charm 😁