ExcelBanter - Create time value from number

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Create time value from number (https://www.excelbanter.com/excel-discussion-misc-queries/166098-create-time-value-number.html)

tom

Create time value from number

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

Create time value from number

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

tom

Create time value from number

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

All times are GMT +1. The time now is 12:02 PM.