Figured it out:

=TIME(A1/100,MOD(A1,100),0)

Thanks!

"Janet Kreinbrink" wrote:

Tried that, but got this message: Microsoft Office Excel cannot use the
number format you typed.

"bob" wrote:

try using this custom frmat: [h]:[m]

"Janet Kreinbrink" wrote:

Hi,
I have a large spreadsheet of data from a cvf file. Column B has the time
in this format: 1700. Can't for the life of me figure out how to chage it to
miliary time (17:00).

Thanks.