Excel sheet help

#1
Dear friends ...

i have excel sheet in which live market price ll be updated from nest ....
from which i need to take first 15 min open , high , low and close values in separate column or next sheet ...

same way i need to plot 30 min , 1 hr OHLC in next sheet ....

how to do this .. guide me ..