I'm still confused. I want to be able to enter the hour and minutes (e.g.
534) and have the format be hours and minutes (e.g. 5:34). This formatting
would apply to a column. Help!

Thanks!

"Myrna Larson" wrote:

You enter Bob's formula in whatever cell it is that you want to see the time
that corresponds to the entry in cell A1.

On 16 Oct 2004 08:37:24 -0700, (Terri) wrote:

Hello, I am having a similar problem. I entered my time in column 'C'
starting row '4'. I entered them as a number with 2 decimal places,
eg...18.12 ...want it to be 18:12. When I change the formatting to
'time', it thinks it's a serial date.
My question is...where do I enter the formula to change my numbers to
TIME?
Thanks

"Bob Phillips" wrote in message
...
=TIME(INT(A1/100), MOD(A1,100),0)

--

HTH

RP

"Vincdc" wrote in message
...
Hello:
I have some data like 415, 537, 2012...
Which function I can use to convert this number to hh:mm format, e.g.
4:15,
5:37 and 20:12?
Thanks in advance!

You need code for that, how else would excel know that 530 is a time and not
the number 530?

http://www.cpearson.com/excel/DateTimeEntry.htm

have code that you can adapt


--

Regards,

Peo Sjoblom

"MaryK" wrote in message
...
I'm still confused. I want to be able to enter the hour and minutes (e.g.
534) and have the format be hours and minutes (e.g. 5:34). This
formatting
would apply to a column. Help!

Thanks!

"Myrna Larson" wrote:

You enter Bob's formula in whatever cell it is that you want to see the
time
that corresponds to the entry in cell A1.

On 16 Oct 2004 08:37:24 -0700, (Terri) wrote:

Hello, I am having a similar problem. I entered my time in column 'C'
starting row '4'. I entered them as a number with 2 decimal places,
eg...18.12 ...want it to be 18:12. When I change the formatting to
'time', it thinks it's a serial date.
My question is...where do I enter the formula to change my numbers to
TIME?
Thanks

"Bob Phillips" wrote in message
...
=TIME(INT(A1/100), MOD(A1,100),0)

--

HTH

RP

"Vincdc" wrote in message
...
Hello:
I have some data like 415, 537, 2012...
Which function I can use to convert this number to hh:mm format,
e.g.
4:15,
5:37 and 20:12?
Thanks in advance!

Thank you for your response. I'll need to give this information to my IT
person. I was under the impression that if you formatted a cell using
Format/Cell/Number/Time, it would format the number entered in the chosen
style. So based on your response, the Format function is useless for this.

"Peo Sjoblom" wrote:

You need code for that, how else would excel know that 530 is a time and not
the number 530?

http://www.cpearson.com/excel/DateTimeEntry.htm

have code that you can adapt


--

Regards,

Peo Sjoblom

"MaryK" wrote in message
...
I'm still confused. I want to be able to enter the hour and minutes (e.g.
534) and have the format be hours and minutes (e.g. 5:34). This
formatting
would apply to a column. Help!

Thanks!

"Myrna Larson" wrote:

You enter Bob's formula in whatever cell it is that you want to see the
time
that corresponds to the entry in cell A1.

On 16 Oct 2004 08:37:24 -0700, (Terri) wrote:

Hello, I am having a similar problem. I entered my time in column 'C'
starting row '4'. I entered them as a number with 2 decimal places,
eg...18.12 ...want it to be 18:12. When I change the formatting to
'time', it thinks it's a serial date.
My question is...where do I enter the formula to change my numbers to
TIME?
Thanks

"Bob Phillips" wrote in message
...
=TIME(INT(A1/100), MOD(A1,100),0)

--

HTH

RP

"Vincdc" wrote in message
...
Hello:
I have some data like 415, 537, 2012...
Which function I can use to convert this number to hh:mm format,
e.g.
4:15,
5:37 and 20:12?
Thanks in advance!

Yes you cannot use formatting to change something from 530 into something
that is 0.229166666666667

one day is 1 in Excel, meaning that one hour is 1/24 thus 5:30 thus 5.5 x
(1/24) while 530 is 12720 hours
formatting will only change the display of something and since you don't use
the colon to show excel it is a time when you enter it you would need code
that will insert the colon for you at the moment you press enter

--
Regards,

Peo Sjoblom

(No private emails please)


"MaryK" wrote in message
...
Thank you for your response. I'll need to give this information to my IT
person. I was under the impression that if you formatted a cell using
Format/Cell/Number/Time, it would format the number entered in the chosen
style. So based on your response, the Format function is useless for
this.

"Peo Sjoblom" wrote:

You need code for that, how else would excel know that 530 is a time and
not
the number 530?

http://www.cpearson.com/excel/DateTimeEntry.htm

have code that you can adapt


--

Regards,

Peo Sjoblom

"MaryK" wrote in message
...
I'm still confused. I want to be able to enter the hour and minutes
(e.g.
534) and have the format be hours and minutes (e.g. 5:34). This
formatting
would apply to a column. Help!

Thanks!

"Myrna Larson" wrote:

You enter Bob's formula in whatever cell it is that you want to see
the
time
that corresponds to the entry in cell A1.

On 16 Oct 2004 08:37:24 -0700, (Terri) wrote:

Hello, I am having a similar problem. I entered my time in column
'C'
starting row '4'. I entered them as a number with 2 decimal places,
eg...18.12 ...want it to be 18:12. When I change the formatting to
'time', it thinks it's a serial date.
My question is...where do I enter the formula to change my numbers
to
TIME?
Thanks

"Bob Phillips" wrote in message
...
=TIME(INT(A1/100), MOD(A1,100),0)

--

HTH

RP

"Vincdc" wrote in message
...
Hello:
I have some data like 415, 537, 2012...
Which function I can use to convert this number to hh:mm format,
e.g.
4:15,
5:37 and 20:12?
Thanks in advance!