software

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

On Sun, 8 Jan 2006 18:37:01 -0800, Jaclyn gt;
wrote:

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

If your hours worked are always less than 24, then:

=EndTime-StartTime (EndTimelt;StartTime)

will work.

If your hours worked might be 24 or greater, you will need to enter dates.--ron

Hi Jaclyn,
If 18:55 day1 is in A1,
3:03 day2 is in B1, then =LEFT(B1,FIND(quot; quot;,B1)-1)-LEFT(A1,FIND(quot;
quot;,A1)-1) 1 in C1 yields 8:08 provided C1 has custom formatting [h]:mm.
Ken Johnson
=B1 24-A1

A1=Start time
B1=End time

Note: Only works within 24 hour time period.--
Vito
------------------------------------------------------------------------
Vito's Profile: www.excelforum.com/member.php...oamp;userid=29182
View this thread: www.excelforum.com/showthread...hreadid=499249Hi 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 Govierquot;Jaclynquot; gt; wrote in message
...
gt;I am making a timecard for workshifts that span two days. There are no
gt;dates
gt; entered into the worksheet. I want excel to find the hours and
gt; minutes from
gt; the start of a shift (18:55 day1) to the end of a shift (3:03 day2).
gt;
gt; Thanks,
gt; Jackie