Date Time Difference...

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Steve
    #1

    Date Time Difference...

    Hello all,

    I was wondering if someone could help me here. Since I'm running and
    iMac, I don't have Visual Basic (6) installed. I want a small function
    returns the number of seconds between two dates.

    Can anyone help me with this? I would appreciate it.

    Thanks,

    Steve

    Tags: None
    • Auric__
      #2
      Re: Date Time Difference...

      On Fri, 28 Dec 2007 01:54:02 GMT, Steve wrote:
      I was wondering if someone could help me here. Since I'm running
      and iMac, I don't have Visual Basic (6) installed. I want a small
      function returns the number of seconds between two dates.
      >
      Can anyone help me with this? I would appreciate it.
      Dim result As Long, day1 As Date, day2 As Date
      day1 = Now
      day2 = Now - 1
      result = DateDiff("s", day1, day2)

      ' If you always want a positive number, then:
      result = Abs(DateDiff("s ", day1, day2))

      --
      Talking to you is like talking to an omelet at times.

      --
      Posted via a free Usenet account from http://www.teranews.com

        Comment

        • myford100@yahoo.com
          #3
          Re: Date Time Difference...

          On Thu, 27 Dec 2007 20:54:02 -0500, Steve <stevetheimacus er@aol.com>
          wrote:
          >Hello all,
          >
          >I was wondering if someone could help me here. Since I'm running and
          >iMac, I don't have Visual Basic (6) installed. I want a small function
          >returns the number of seconds between two dates.
          >
          >Can anyone help me with this? I would appreciate it.
          >
          >Thanks,
          >
          >Steve
          Are you wanting the VB function or just the number of seconds? If the
          latter, set up a simple spreadsheet and you'll even be able to format
          the result the way you want.

            Comment

            • Auric__
              #4
              Re: Date Time Difference...

              On Tue, 01 Jan 2008 11:49:22 GMT, wrote:
              On Thu, 27 Dec 2007 20:54:02 -0500, Steve
              <stevetheimacus er@aol.comwrote :
              >
              >>I was wondering if someone could help me here. Since I'm running
              >>and iMac, I don't have Visual Basic (6) installed. I want a small
              >>function returns the number of seconds between two dates.
              >>
              >>Can anyone help me with this? I would appreciate it.
              >
              Are you wanting the VB function or just the number of seconds? If
              the latter, set up a simple spreadsheet and you'll even be able to
              format the result the way you want.
              Since this is a VB group, and not a spreadsheet/excel/office/whatever
              group, I think it's safe to assume that the OP wanted to do this
              programmaticall y.

              --
              Stupid asshole.

              --
              Posted via a free Usenet account from http://www.teranews.com

                Comment

                Previous template Next
                Working...