All of the replies assume you have the full date and time in the cells, and
your follow ups suggest that you do not. If there is no date, then Excel has
no way to know what you want to do. You can of course add stuff to your
formulas that add 1 to A-B if B is less than A, but if your times span more
than one midnight, or even if they span more than 24 hours, this isn't good
enough.

You should either go back and fix your times so they also include a date
(and always do this henceforth), or use another pair of columns to contain
the dates, and use these in your subtraction.

Maybe this sounds like a pain. but Excel works best when the data it is fed
is "good" data. You can spend ten minutes with your data, or ten hours
trying to fix the results.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"wahoos" wrote in message
...
I'm trying to find the difference between start time and end time when the
total time will exceed a 24 hour period.

10:00 PM Friday 3:00 AM Sun