=--(SUBSTITUTE(E1,".",":"))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"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