Selected time copying

[thong127]

Hello Gurus,

I need your help again,

On my Attached File, I have a Data Sheet and I want only to copy the value of the Humidity & Temperature base on the value of time ending in :02 Like ( 9/13/2018 12:02:00 AM ; 9/13/2018 1:02:00 AM ; 9/13/2018 2:02:00 AM....) on the other sheet from September 13 up to Sept 20.

The format will be like in the "Format Sheet" of the attached file.

cross posted: https://www.excelguru.ca/forums/show...d-time-copying

Thank you