Hi all, I did a basic search and couldn't find this, but I'm hoping someone has the answer.
I have a master sheet made up of several logs from various people that includes a list of times, but not everyone uses the same time format (there's at least h:mm, 00\:00, hh:mm...)
All attempts to change this master list to the same format results in a portion of them screwing up.
Thinking outside the box, I created a list of the number that Excel sees these times as (0.000694444444444444 and 1 equal 00:01, depending on what format they're coming from) and then tried a VLOOKUP to insert the correct time in the next column. It worked fine for the whole numbers, but those crazy long decimals came up N/A. I tried rounding them in both columns thinking maybe there were additional digits that I couldn't see, but that made no difference.
Any suggestions?
Bookmarks