@ConcreteKid
To elaborate a bit on the point that @SergeiBaklan makes, when he says, "If you'd like to convert the text "0502" into the time 05:02 which is equal to number 0.209722222222222 - perhaps with VBA" --the implications of this are that IF you are planning to calculate elapsed time between 05:02 and say 15:22, then you need to have it not just "appear to your human eye" a certain way, AS IF it were time, but you'd need to have the underlying value be something that Excel recognizes as time.
I have no idea how one would use VBA to convert--not a VBA user myself--but it's important that you realize the distinction between the appearance of a time value and the actual underlying data. You gave no reason for your request, which is why I wanted to add this point of clarification.
