avregeing data acording to date and time

Hi ionutzul

If you require a column next to your data, try in D1 and copy down:

Formula:

=IF(COUNTIF($A$1:A1,A1)>1,"",AVERAGEIF($A$1:$A$193,A1,$C$1:$C$193))