i am trying to do a simple vlookup and am having problems bc one report is in GMT time zone and one report is in PST. here are the two cells that i want to match but need to convert one of them.
11/19/2014 22:14:06 GMT
2014-11-19 14:14:06
I have tried a TIME formula but unsucessful bc of the date in the cell. i know i can seperate the cell with text to column, but wanted to check with the experts on the forum to avoid the manual spilting and rejoing of the cells. thanks for taking time to look!! any suggesting appreciated!
Bookmarks