Sorry, but the extra-sensory perception facility in Excel hasn't been
introduced yet. It can't guess what you wanted. You need to tell it
(either individually when you enter data in a cell, or by defining an
algorithm by which the day can be determined based on other data). How is
Excel supposed to guess that when you said 3:00 AM you meant Sunday, not
Saturday or Wednesday?
--
David Biddulph

"wahoos" wrote in message
...
How would I format the fields so excel would know when I entered 3:00AM-
it
was Sunday, when the job was started on Friday at 10PM?

"Mike H" wrote:

You can't just say

10:00 PM Friday 3:00 AM Sun
you need a date and a time and then it's simply

=b1-a1

where B1 is the later date/time

format the answer as [hh]:mm

Mike

"wahoos" wrote:

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