Do a Find and Replace (CTRL-H) replacing all . with :

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Meb" wrote in message ...
|I received an excel spreadsheet where data for time was entered in two
| columns with a decimal point instead of a colon (e.g the time of twelve
| thirty four was entered as 12.34 instead of 12:34). Is there any way I can
| insert a formula to convert the data to the correct format so that I can
| calculate the time elapsed correctly? Thanks