I am fairly new to Excel and I'm working on creating an excel sheet that figures the minutes between clock in and clock out times.
For example, if I clock in at 9:00 AM and clock out at 12:30 PM, I would see hours and minutes 3:30
I have been able to do this, but I'm looking for a way to make that calculation work with or without having to put a space before the AM & PM. So that time entered as 9:00 AM or 9:00am or 9:00AM would all calculate correctly? I've searched everywhere and I just can not figure this out.

Once the employee enters their clock in and clock out times, there is a drop down box to show what the clock out was for ie lunch , break, end of day etc... Is there a way to have the number of minutes calculated automatically go into a certain cell depending on which option is chosen from that drop down ? I have columns for lunch, break, training etc.... For example, if I choose lunch from the drop down, then the number of minutes I was at lunch, will auto populate in the lunch column.

Excel Example.JPG