Time question-displayed as a fraction

This is probably an easy question, but im still stumped.

I have a Form that a user types in a time, say 12:50 PM, then saves the form.
But whenever that cell is recalled in to the form it gets displayed as a fraction, say 0.534722222222222 . I tried formatting the cells as Time, but no use.

Excel saves times as a decimal and displays that decimal in the format that you set.


When getting cell values you do not get the formatting with it

You will need to format your data in the form berfore displaying it

try

Format(0.534722222222222, "hh:mm")

thanks, I thought it was something like that