is it possible to specify the timeframe in an array?

 
i am trying to do a monthly pivot with shift. have to use 1 hr candles to do the calculations. if i am doing an array of finding the close of a 1 hr candle on a daily chart. is it possible?