Identifying gaps in a timeline

[lenart11]

I have 3 columns of data. Date, In time, Out time. The data represents the utilization of a facility. I need to know when the facility was not being used. I need to see where the gaps are. Is there a way to graph this with a timeline that shows gaps when the facility was not in use? That would be ideal. Any other suggestions are greatly appreciated.

Thanks,
Mike

 

[Gerald Higgins]

Hi Mike, welcome to the board.

Without a doubt, there ARE ways to graph this data.

But your request is too vague. Please can you explain in more detail what you are trying to do ?

 

[wsjackman]

convert the day and time info into actual time date value

maybe
if they are in time and date format already its as simple as =a1+b1

subtract each out time date+time from the next in time date plus time
plot this new out duration data and interpret it as you wish.

I would probably plot it against the date time columns.

You may want to do some more to eliminate weekends or other scheduled outages