How do I convert text to time
 

I am trying to create a time tracking sheet that allows me to put in the hour
as a number - 0800 and will convert the information to time. IE 08:00 AM

How do I convert text to time
 

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

--
Kind regards,

Niek Otten

"Curtis" wrote in message
...
I am trying to create a time tracking sheet that allows me to put in the
hour
as a number - 0800 and will convert the information to time. IE 08:00 AM

How do I convert text to time
 

See if Chip's site will help you:
http://www.cpearson.com/excel/DateTimeEntry.htm
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"Curtis" wrote in message
...
I am trying to create a time tracking sheet that allows me to put in the
hour
as a number - 0800 and will convert the information to time. IE 08:00 AM

How do I convert text to time
 

Hi!

Using another cell:

A1 = 0800
B1 = formula

=TIME(LEFT(A1,2),RIGHT(A1,2),0)

Biff

"Curtis" wrote in message
...
I am trying to create a time tracking sheet that allows me to put in the
hour
as a number - 0800 and will convert the information to time. IE 08:00 AM

How do I convert text to time
 

HOw would you use this with a vlookup?

"Biff" wrote:

Hi!

Using another cell:

A1 = 0800
B1 = formula

=TIME(LEFT(A1,2),RIGHT(A1,2),0)

Biff

"Curtis" wrote in message
...
I am trying to create a time tracking sheet that allows me to put in the
hour
as a number - 0800 and will convert the information to time. IE 08:00 AM