• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 166
  • Last Modified:

time problem

Doesn anybody know how to calculate a time difference,

when i write some code to get the result of say (9pm - 8am) it keeps adding 12 hours on.

but if i do it from 1am - 6am then it works the time out correct.

can somebody show me some code that gives me the hours difference from 8pm - 6am.

cheers
Andy
0
andysalih
Asked:
andysalih
  • 4
  • 4
  • 2
  • +1
1 Solution
 
glass_cookieCommented:
Hi!

You could use the datediff function to do that.  Here's the extract from my help file (use 'h'):


Returns a Variant (Long) specifying the number of time intervals between two specified dates.

Syntax

DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]])

The DateDiff function syntax has these named arguments:

Part     Description
interval     Required. String expression that is the interval of time you use to calculate the difference between date1 and date2.
date1, date2     Required; Variant (Date). Two dates you want to use in the calculation.
firstdayofweek     Optional. A constant that specifies the first day of the week. If not specified, Sunday is assumed.
firstweekofyear     Optional. A constant that specifies the first week of the year. If not specified, the first week is assumed to be the week in which January 1 occurs.
Settings

The interval argument has these settings:

Setting     Description
yyyy     Year
q     Quarter
m     Month
y     Day of year
d     Day
w     Weekday
ww     Week
h     Hour
n     Minute
s     Second

That's it!

glass cookie : )
0
 
priya_pbkCommented:
hi andysalih,

Try this,
X = Abs(DateDiff("H", "21:00:00", "8:00:00"))

where the time is in 24hr format

hope this helps!

-priya
0
 
glass_cookieCommented:
Oops - now I get what you mean.  Since the datediff function also gives you the same problem, how about reversing the time?  As in...

Instead of:

MsgBox DateDiff("h", "8:00 PM", "6:00 AM")

You do something like:

MsgBox DateDiff("h", "6:00 PM", "8:00 AM")

Of course, you'll need some coding to determine is the switching is required by using the instr function to check for 'AM' or 'PM'

That's it!

glass cookie ; )
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
priya_pbkCommented:

therefore X would return "13"

0
 
LJuniorCommented:
Hello,

if the two 'times' are not within the same day you've got to use the date to tell the DateDiff function what to do

DateDiff("H", "01/01/2002 21:00:00", "01/02/2002 8:00:00")
0
 
andysalihAuthor Commented:
i dont understand the calcs here

in my world 9pm - 8am in the morning is 11 hours, How can it be 13.

why is it returning the value 13


cheers

Andy
0
 
priya_pbkCommented:
oops!! sorry abt that, happens in my world too!


MsgBox DateDiff("H", Format("27/07/2002 21:00:00", "dd-mm-yyyy hh:mm:ss"), Format("28/07/2002 08:00:00", "dd-mm-yyyy hh:mm:ss"))



0
 
andysalihAuthor Commented:
i dont understand the calcs here

in my world 9pm - 8am in the morning is 11 hours, How can it be 13.

why is it returning the value 13


cheers

Andy
0
 
andysalihAuthor Commented:
oops. REFRESHED by mistake sorry guys
0
 
priya_pbkCommented:

'Formatted:

Private Sub Command1_click()

MsgBox DateDiff("H", Format("27/07/2002 21:00:00", "dd-mm-yyyy hh:mm:ss"), Format("28/07/2002 08:00:00",
"dd-mm-yyyy hh:mm:ss"))

'the above returns 11

MsgBox DateDiff("H", Format("27/07/2002 20:00:00", "dd-mm-yyyy hh:mm:ss"), Format("28/07/2002 06:00:00", "dd-mm-yyyy hh:mm:ss"))

'this returns 10

End Sub


-priya

0
 
andysalihAuthor Commented:
thats the one,

cheers
Andy
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 4
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now