Rene asks "I would like to know how I could actually remove the colon from the time value without it turning to decimal. example when the time value is entered 23:59, I would like it to automatically change to 2359"

Strange question... I always seem to find questions about going the other way. Anyway, if your time is in A1, use this formula:

=TEXT(A1,"hhmm")