convert it

=TIME(LEFT(A1,2),RIGHT(A1,2),0)

--
HTH

Bob

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

"jenn" wrote in message
...
Hi,

I have entered all my times as xxxx now I want to be able to use them with
a
date to calculate the difference between two dates and times so I have to
change all the times to xx:xx

example: 1200 needs to be 12:00 so I can go 5-jan-07 12:00 - 4-jan-07
8:00,
the times and dates are in different columns

Thanks for your help