Create time value from number

[Guest]

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

 

[Niek Otten]

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

|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

 

[Guest]

tHAT DID IT.... tHANX