Register
Log In
Unanswered
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
Most Users Ever Online: 57
Currently Online: Max Neumann
20 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Ajay Mukhi
Stephen Motte
Rodney Hoyle
michael pitre
Samantha Burleson
Krishnaa Kurugod
David McSwain
Shameem Nassiree
Alanna Henderson
Janel Oz
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
