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.