Calculating Hours for Overlapping Time/Date Fields

  • Thread starter Thread starter Phil Sandler
  • Start date Start date
P

Phil Sandler

All,

I have a worksheet with a bunch of time/date fields that track
start/end times for processes. Here is an example of the type of
data. They have dates as well, but I am not using the dates in my
examples to make this simpler to read.

Start End
8:00 AM 8:45 AM
8:10 AM 9:00 AM
8:20 AM 8:30 AM


There are hundreds of records like this. Sometimes they overlap, and
sometimes they don't.

What I want to do is calculate the total time, where overlaps don't
get double- or triple- counted. The above example's total time would
be one hour.

Hopefully my question makes sense. Thanks very much for any help!


Phil
 
Hi Phil
not quite sure but if you don't have free times in between you may use
=MAX(B1:B20)-MIN(A1:A20)
and format the resulting cell as time
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Determine if night shift by start & end time 2
Calculation Total Time With Dates/Times That Overlaps 4
Calculating diff between date/ time only between certain hours 4
Calculating Time 3
Calculating Overlaps 3
Calc time with a lookback #2 7
Average Time for Specific Item 9
time calculations 2

Back
Top