![]() |
|
#2
|
|||
|
|||
|
I had to convert the date/time to US from euro to get this to work using the date/time in the corresponding cells.
In A2 I used =SUM(B1-A1) In A3 I used =SUM(D1-C1) In A4 I used =SUM(A2,A3) A2-A4 I formatted cells custom HH:MM:SS A1: 05:05:36 B1: 01:02:32 C1: 06:08:08 Sorry, didn't see that you wanted to exclude weekends. Found this in another thread that mau point you in the right direction: =IF(COUNTIF(HOLIDAYS!$C$4:$C$14,A5),"h",IF(OR(F5=" Sat",F5="Sun")," ",SUMPRODUCT(--(WEEKDAY(A5+1-ROW(INDIRECT("1:"&DAY(A5))),2)<6),--ISNA(MATCH(A5+1-ROW(INDIRECT("1:"&DAY(A5))),HOLIDAYS!$C$4:HOLIDAYS !$C$14,0)))) Hope this helps, If it's acting odd, try switching to US Dates |
| Tags |
| date, formulae, time |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Need a formula to calculate turnaround time
|
Rockitman31 | Excel | 9 | 09-07-2015 09:41 AM |
Formula to auto calculate Day of the week based on Date
|
prasad@dmci.ca | Excel | 1 | 11-29-2011 01:05 PM |
Calculate elapsed time in Word table?
|
Snvlsfoal | Word Tables | 1 | 08-11-2011 05:42 AM |
What formula should I use to calculate commission?
|
grs | Excel | 3 | 02-21-2011 02:17 AM |
How to get cells to calculate time?
|
jrasche2003@yahoo.com | Excel | 2 | 02-09-2007 07:10 AM |