| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Eliminate Overlapping Entries
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In 2 Excel worksheets, I am trying to eliminate duplicate entries | Excel Worksheet Functions | |||
| Table to pick out most common entries and count occurences of each | Excel Worksheet Functions | |||
| How do I change multi-line entries to single line entries in Exce. | Excel Worksheet Functions | |||
| count duplicate (or, inversely, unique) entries, but based on a condition | Excel Worksheet Functions | |||
| How to eliminate duplicate entries | Excel Discussion (Misc queries) | |||
Threaded Mode
