in attached excel file, the is
"server uptime" tab- this provides the server uptime in 30 min interval where data is not available it gets reflected in "Summary" tab as "pass" or "fail".
"Incidents-logged": Also included is the number of incidents logged in during the day with date and time.
I would like to have extra information on the Summary tab:
if there is incident logged during the day, the count of incident should reflect the 30 minute time slot.
if there 4 incidents on 1 july between time slot 8am to 8.30am then
pass data should reflect
Pass (4) in the the summary tab .
Please could you help me.