Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel should allow to add and subtract times | Excel Worksheet Functions |