If you want to convert 800 to 08:00 and 1700 to 17:00 you can use this
formula

=--TEXT(A1,"00\:00")

then format the cell as hh:mm



--
Regards,

Peo Sjoblom

"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?

Thanks

"Bob Phillips" wrote:

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