tHAT DID IT.... tHANX

"Niek Otten" wrote:

HI Tom,

Just one example, not too much!

OK,

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

Format as hh:mm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Tom" wrote in message ...
|I have a column of numbers that I would like to turn into a time value.
| Example the number 1520 would be 15:20. I've been thru the functions but
| can't find what I want. Can anyone help??
|
| Thanx
| Tom