I would like to enter the in and out times for each employee on my schedule
spreadsheet in normal format (e.g. 11:00pm - 7:00am) and have it calculate
how many hours the emploee worked. Everything works well until I have an
employee who works the night shift. The subtraction of 11pm to 7am gives me
a negative and incorrect anser. How can I achieve this and still use normal
format times as above?

Rudy