How to subtract times i.e. 18:55 day1 from 03:03 day2
 

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

How to subtract times i.e. 18:55 day1 from 03:03 day2
 

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

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

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

=EndTime-StartTime+(EndTime<StartTime)

will work.

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


--ron

How to subtract times i.e. 18:55 day1 from 03:03 day2
 

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

How to subtract times i.e. 18:55 day1 from 03:03 day2
 

=B1+24-A1

A1=Start time
B1=End time

Note: Only works within 24 hour time period.


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=499249

How to subtract times i.e. 18:55 day1 from 03:03 day2
 

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