Log In
Register
Home
New Member
June 14, 2017
Offline
Hello. I would like help calculating total free/unused time (in days or hours) between two dates/times, given multiple overlapping time spans. For example, I would like to calculate the total unused time between 5/1/16 0:00 and 5/31/16 23:59. The multiple time spans in the attachment represent the 'used' time that I want to exclude to arrive at total free/unused time.
Any help would be very appreciated :).
See Answer
July 16, 2010
Offline
Hi Brent,
That sure is a brain teaser and given the lack of response to your question, I'm not the only one to think so.
I can't say I have an answer for you, but in the attached file I've added a chart so you can visualise the gaps in time, which may help you get a feel for the free/unused time, of which there is very little.
Mynda
July 16, 2010
Offline
Hi again,
Please see the revised file attached. Column D contains a formula that I think does what you want. You can change the start and end dates in your data set to calculate for the desired period, as opposed to the start and end dates of the data set.
Mynda
Answers Post
1 Guest(s)
