XLookup not returning values using hh:mm format as lookup

[JeffGrant]

Hi all,

I have a time look up value in the format of hh:mm, eg 12:08.
I have a lookup column in the same format
I have a return column of the number of times that particular time occurs, which is an integer value determined by the CountIf function.

I would like the Xlookup function to lookup the time (12:08) and return the number of occurrences.

However, despite much searching, my Xlookup formula only ever returns the N/A error.

I have tried all sorts or possible solutions using text, time, hour & minute functions, all to no avail.

I suspect it has something to do with the way excel stores time.

I am completely out of ideas on this one. Any and all guidance is very much appreciated.

Thanks in advance for your help.

 

[JeffGrant]

problem solved. for this exercise, I have simply removed all formats from all cells and columns involved and it work.....