First you need to link your tables, e.g. by renaming your CustomerAccess to Category or duplicating it:
[Customer Access] as Category,
(biff, embedded labels, table is Data$);
time(alt(AccessStartTime,time#(AccessStartTime,'hh:mm'))) as AccessStartTime,
time(alt(AccessEndTime,time#(AccessEndTime,'hh:mm'))) as AccessEndTime
(biff, embedded labels, table is AccessTime$);
I also needed to take care of your different time formats in your excel file (that's why I needed to use alt() function).
Then just create a straight table chart with dimensions TermId,Customer Access, FaultStartTime and FaultEndTime and use as expression to filter on Category:
=if(frac(FaultStartTime) <= AccessEndTime and frac(FaultStartTime) >= AccessStartTime, Mins,0)
Check the supress zero values is enabled in presentation tab.
Hope this helps,
comm46658.qvw 144.5 K