Create time value from number

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top