Hi
not that much data/information. Lets assume you have in
column a a date/time value and in column B the values for
which you want to get the average.

Enter the following array formula (with CTRL+SHIFT+ENTER):
=AVERAGE(IF((A1:A1000<=NOW())*(A1:A1000=NOW()+1), B1:B1000)

-----Original Message-----
We have some hourly data for every day 24hours, is it
possible to get the average for latest 24 hours. if so
pelase help me.

Thanks in advance
.