Countif with lead time criteria

[sangeetha]

My data is in sheet NtoR:
Col F has start date Time
Col P has End date Time
Col Q has lead time in custom: [h]:mm:ss format

I need to count number of records within specific start date and end date (and some more criteria) and lead time less than 24, between 24~48 and more than 48 hours.

I am not good at arrays. So I need some help here.

 

[Somendra Misra]

Hi,

See the file, Weekly dashboard sheet. Orange cells has formula.

Regards,

 

[sangeetha]

Thankyou Misra sirji.
Great help, timely.

 

[Somendra Misra]

You are Welcome!!!

Regards,