*resolved* Excel VBA - best variable to store time

I'm trying to store a time stamp from a worksheet in a variable but I don't know the best type. The time stamp goes down to the second (I think) so for instance 00:40:49 is 0.028344907 in a cell that is in General number format. However regardless of whether or not the time stamp is actually to the second I have to be able to store the full decimal in the variable.

Am I best storing the value in a double precision variable? Would this give me the resolution I need?

Thanks
-Rob