jimgus
08-14-2008, 03:14 PM
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: