By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,057 Members | 1,346 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,057 IT Pros & Developers. It's quick & easy.

Date Time Difference...

P: n/a
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

Dec 28 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Dec 28 '07 #2

P: n/a
On Thu, 27 Dec 2007 20:54:02 -0500, Steve <st**************@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.
Jan 1 '08 #3

P: n/a
On Tue, 01 Jan 2008 11:49:22 GMT, wrote:
On Thu, 27 Dec 2007 20:54:02 -0500, Steve
<st**************@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
programmatically.

--
Stupid asshole.

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

Jan 2 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.