Results 1 to 2 of 2

Thread: *resolved* Excel VBA - best variable to store time

Threaded View

  1. Aug 17th, 2012, 04:18 AM #1
    TheRobster
    TheRobster is offline

    Thread Starter
    Hyperactive Member
    Join Date
    May 2004
    Location
    Right here
    Posts
    275

    *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
    Last edited by TheRobster; Aug 17th, 2012 at 06:00 AM. Reason: resolved
    http://www.sudsolutions.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width