The table I access has a time value saved as an integer. For example, 6:05 PM (18:05) is saved as 1,805. I need to be able to convert this to the 24hr time of 18:05. I cannot change the table format, only via my SELECT query. Can anyone help me with this?

I greatly appreciate any insight!
Rita Brasher