You may want to include the date and time in the cell. Then you can do just
regular arithmetic to get the hours.

mailrail wrote:

I'm trying to write a formula that will calculate my employees' total time
worked. A problem arises when I have people scheduled to work past midnight.
If, say, someone works from 9 pm until 3 am, how do I get Excel to recognize
the change in dates and properly figure the time?

--

Dave Peterson