Referencing multiple items

This method works fine save when one of the columns contains time. Do you know why it would do that?

Hi,

It should work with any value. A Time is just another value, specifically a decimal of 24 hours, so you should see for instance 0.5 for 12:00 noon. So concatenating a Time and a Name you should see "0.5Bill"

Why do you think it's not working, or are you saying that you have a volatile =Time(hh,mm,ss) function which keeps changing?

Rgds

I have time in the format "hh:mm:ss" and the two times that I am trying to correlate differ by some milliseconds.. which I think is due to rounding. For some reason I can't get them to match, I used function round but no use. The method you mentioned works perfect.. I am just trying to figure out how it would work for this scenario. Thank you for all your help.