I have a file with multiple rows of time "in" and time "out" entries. I
am trying to get a grand total of time entered. The problem is that
some entries overlap with others. Here is an example:
20060201 10:00 AM 11:00 AM 10:00 11:00 1:00
20060201 9:30 AM 10:15 AM 9:30 10:15 0:45
20060201 9:30 AM 9:45 AM 9:30 9:45 0:15
All of these entries occured on 2/1/06 so they are overlapping each
other. The actual total time should be 1:30 (9:30 AM - 11:00 AM). Is
there a way to avoid a result of 2:00?
Thanks
Mark
--
Mark@Marc
------------------------------------------------------------------------
Mark@Marc's Profile:
http://www.excelforum.com/member.php...o&userid=28126
View this thread:
http://www.excelforum.com/showthread...hreadid=513668