allananthony
New Member
- Joined
- Jul 29, 2014
- Messages
- 3
I was given an existing workbook containing the daily schedules of all employees. The cells under each employees names have the format (ex.) 8am-5pm. What is the formula to convert this into the format 8:00am-5:00pm on a different cell? I am trying to create a workbook where the actual sign in time will be input and from there show if the employee was on time or late. (I am not allowed to make any changes on the existing work book.)