Im looking for a way to allow the users of my spreadsheet to enter the time using a . or a :, so 7.30 would convert to 07:30 (and 7:30 would be acceptable input as well).

I know this is possible but I just cannot seem to figure out how, any help would be appreciated.