MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Working with Time Formats


February 19, 2002 - by Juan Pablo Gonzalez

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")