Solved: Formatting cells with times

[jimgus]

I am currently working on a timesheet using excel. I am trying to format the cells so that when an employee enters a time the program will add the colon. I have noticed that if I rely on the employee to add the colon they forget. Example: Employee enters 1600 and the spreadsheet shows this as 16:00. Probably an easy way to do this but it escapes me. Thanks for any help. :banghead: :banghead: :banghead:

[Bob Phillips]

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

[david000]

=TIMEVALUE(LEFT(TEXT(A1,"0000"),2)&":"&RIGHT(TEXT(A1,"0000"),2))

[jimgus]

Thanks. Exactly what I needed. jrg