Christian_Ku
Board Regular
- Joined
- Sep 10, 2007
- Messages
- 102
Hello,
I have a column with time values that differ approximately 30s of each other (e.g. 00:01:34, 00:02:04, etc.). The column next to it contains data measured at that time. Now I only need the data until, say, 12:00:00, however most of the time this exact value does not exist, it is either 11:59:47 or 12:00:13.
So when I try to use the find function I usually get the 00:01:12 or somthing like that, if I use "12:" I get 00:12:33 or something like that. In any case with the find function used in this fashion I will never get 12:00:00 or the value closest to it in the way I'm using it now. I've searched this site over and over but I could not find anything and the excel 2003 help file is completely useless when one uses the search function. Hopefully it can be done (i think it can). Thanks
I have a column with time values that differ approximately 30s of each other (e.g. 00:01:34, 00:02:04, etc.). The column next to it contains data measured at that time. Now I only need the data until, say, 12:00:00, however most of the time this exact value does not exist, it is either 11:59:47 or 12:00:13.
So when I try to use the find function I usually get the 00:01:12 or somthing like that, if I use "12:" I get 00:12:33 or something like that. In any case with the find function used in this fashion I will never get 12:00:00 or the value closest to it in the way I'm using it now. I've searched this site over and over but I could not find anything and the excel 2003 help file is completely useless when one uses the search function. Hopefully it can be done (i think it can). Thanks