Time conversion in excel

February 27, 2009 at 00:05:58
Specs: Windows XP
I have time entered as hour:minutes (example 14:30 (that's 2:30PM). I want to eliminate the : so that it reads 1430.

Anyone have a formula to do that??

See More: Time conversion in excel

Report •

February 27, 2009 at 03:02:57
go to format cells and choose "custom" format, and remove the : from the box that appears.

should end up looking like "hhmm" (without the quotation marks"

Report •
Related Solutions

Ask Question