Time and Date Value Formatting

Hi there,

I am trying to run a few calculations in particular a VLOOKUP using time values. Now, I have googled the issue extensively and understand the varying formats that a time value could have will impact the ability of the lookup to find a match. As a result, I am using the standard off-the-shelf time value formatting from Excel (hh:mm:ss). Some of my data is pulling, but not all. For example, my 00:00:25 time stamp is not pulling through. The reason why this is, is because in Tab 1 the underlying number is 0.000324074074074073, and in Tab 2 the underlying number is 0.000324074074074074, i.e. the last dp is slightly different.

I can not work out why this is? Formatting is the same. I am trying built a re-usable template, so while pasting one value over the top will probably work it is not a scaleable and reliable solution.

Any thoughts on why/how this happens and ways around it would be much appreciated.

Thanks,

Mike