I have a spreadsheet that I need to create to track the login and logouts of phones in a call center. This spreadsheet is also used to track how log someone has been on lunch and break. I have over two hundred names to enter with a minimum of 8 in and out times. We only use military time so it is faster for me to key in the time without using the colon. I found a code to format the cell so I can just enter in numbers and it converts it to the military time including seconds, which is what i needed. The problem comes when i need to calculate the login and out time. I need to subtract the time out from the time in minus a 30 minute lunch break and be able to show if they were under 8 hours worked or over. By using the ##":"##":"## code it doesn't give me the right answer. So I am guessing I can't use this code to get this result. Does anyone have any suggestions? I barely know how to use VBA so unless it is a copy and paste, I'm usually lost using that, which is why the above formula was useful.