Try
=TIME(LEFT(A1,LEN(A1)-2),RIGHT(A1,2),0)
--
David Biddulph

"jenn" wrote in message
...
Hi

Thanks that worked for most of the time except I forgot to mention that
there are times that are xxx, like 800, the formula that you gave me add
an
hour to these, will I have to do them separate?

"Bob Phillips" wrote:

convert it

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

"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