liorsitkovsky
New Member
- Joined
- Sep 15, 2006
- Messages
- 9
Hello all.
I have been getting allot of help with my problem and I am close to solving it now.
The last thing (I hope) I need help with is changing the format of my time in my database in order for my vlookup formula to work. I am trying to divide my database into 3 or 4 time intervals and I can make the formula work but only when I change the time format from:
09:51:07.887 to 9:51:07
I am able to do this but only manually line by line and not for the all column. There are over 13000 rows so you can probably understand my frustration. I tried formatting the cell/s but it won't change. I wouldn't mind leaving the time format as it is and using the same format in my array table for the vlookup formula but that doesn't work either.
Any help would be appreciated.
Lior
I have been getting allot of help with my problem and I am close to solving it now.
The last thing (I hope) I need help with is changing the format of my time in my database in order for my vlookup formula to work. I am trying to divide my database into 3 or 4 time intervals and I can make the formula work but only when I change the time format from:
09:51:07.887 to 9:51:07
I am able to do this but only manually line by line and not for the all column. There are over 13000 rows so you can probably understand my frustration. I tried formatting the cell/s but it won't change. I wouldn't mind leaving the time format as it is and using the same format in my array table for the vlookup formula but that doesn't work either.
Any help would be appreciated.
Lior