Hi Jaclyn

With start time in A1 and end time in B1
=MOD(B1-A1,1)
will deal with the times within the same day, or crossing two days.

--
Regards

Roger Govier


"Jaclyn" wrote in message
...
I am making a timecard for workshifts that span two days. There are no
dates
entered into the worksheet. I want excel to find the hours and
minutes from
the start of a shift (18:55 day1) to the end of a shift (3:03 day2).

Thanks,
Jackie