Hi,
Appreciate if anyone could help me on this. I have in ROW 435
Cell A= 11 Mar 2009 (format is date)
Cell B = 1041 (formatted as special "0000". It is to be entered as military
format, but ignore the colon)
Cell C = 17 Mar 2009(formatred as date)
Cell D = 1759 (formatted as special "0000". It is to be entered as military
format, but ignore the colon)
In Cell E435, I have this as formula to calculate the difference:
=INT(C435+(TIME(LEFT(D435,LEN(D435)-2),RIGHT(D435,2),))-(A435+(TIME(LEFT(B435,LEN(B435)-2),RIGHT(B435,2),))))&"
days
"&TEXT(MOD(C435+(TIME(LEFT(D435,LEN(D435)-2),RIGHT(D435,2),))-(A435+(TIME(LEFT(B435,LEN(B435)-2),RIGHT(B435,2),))),1),"HH:MM")
and the result is "6 days 07:18", which is correct.

However, between this 2 dates, there is a weekend (14 ~ 15 Mar). How can I
exclude this and show the result as "4 days 07:18"??
Not sure how complicated is this formula going to be, but if the result can
be in total hours, I am good too.
Thanks a million!