How do I convert text to time

[Curtis]

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

 

[Niek Otten]

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

 

[Anne Troy]

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

 

[Biff]

Hi!

Using another cell:

A1 = 0800
B1 = formula

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

Biff

 

[JR]

HOw would you use this with a vlookup?

Hi!

Using another cell:

A1 = 0800
B1 = formula

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

Biff