Regarding min/max time

[ranakki_99]

hi,
i have a data table as per the 15 min time for 24 hours. I have to show the min/max time as per the data. I tried every formula i knew but its not working. I have time in AG column and my data is in AH.

=AH12=MIN(IF(TIMEVALUE(AG12)=TIMEVALUE(AG12:AG107),AH12:AH107))

currently I used this array but its not working also. anyone has any idea what to do..???

 

[steve the fish]

Hi. Like this perhaps?

=MIN(IF(AH12:AH107=AH12,AG12:AG107))

Will require CTRL-SHIFT-ENTER not just ENTER to commit to cell.

 

[ranakki_99]

yes i did but every time i try to put this formula it wont show anything just the "#value" displays.

 

[steve the fish]

You have ignored the crucial part. Read the last sentence.

 

[ranakki_99]

ohh sorry. yes it worked. Thank you so much.