problem in the excel programming in countif

[vivekgs2007]

I am using the count if statement in programing..i got the problem in displaying the result..

=COUNTIF(G7:AI7,">13:30")

i want to display the calculated result in Ak5..but it is not coming...lease help me that...

[NeoPa]

I think you're simply missing the Date/Time literals. Try :

=COUNTIF(G7:AI7,">#13:30#")

[vivekgs2007]

ok i get the answer the problem is in the format cells..thank you very much for your concern...

[NeoPa]

A pleasure to help :)