GET TOTAL TIME

hey guys i juss wanna ask ur help getting the total time of my project... in my table, i have datetime_in, datetime_out, total_time...

e.g
datetime_in= 04/17/04 10:00:00 AM
datetime_out=04/23/04 10:00:00 PM
total_time=?

thanks
zack_onlineAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
GrahamSkanConnect With a Mentor RetiredCommented:
I'm having trouble understanding you, but I hope this is what you need. It also demonstrates the DateDiff function which shows the elapsed time in particular units, seconds in this case.

Private Sub Command1_Click()
    Dim DateTime_In As Date
    Dim DateTime_Out As Date
    Dim Total_Time As Date
   
    DateTime_In = Now()
    MsgBox "Hello Zack"
   
    DateTime_Out = Now()
    Total_Time = DateTime_Out - DateTime_In
    MsgBox "Time to respond was " & Total_Time & " or " & DateDiff("s", DateTime_In, DateTime_Out) & " seconds"
End Sub


0
 
GrahamSkanRetiredCommented:
Hi zack_online,

Total_Time = DateTime_Out - DateTime_In
(all three should be declared as Date type)
Cheers!
0
 
zack_onlineAuthor Commented:
tnx 4 d reply... how do i get the result in vb? can u gimme a simple sample of this...

tnx again
0
 
MortimerCatCommented:
Dim datetime_in As Date
Dim datetime_out As Date
Dim total_time As Long

datetime_in = #4/17/2004 10:00:00 AM#
datetime_out = #4/23/2004 10:00:00 PM#

total_time = DateDiff("d", datetime_in, datetime_out)

MsgBox total_time

The first parameter "d" indicates how accurate you want the answer.  "d" for days "h" for hours See Help for other settings.

The program above shows 6 ie 6 days.

"h" gives 156 hours.  This will need further manipulation, ie dividing by 24, to get Days &  Hours

See also Datepart & Dateadd
0
 
zack_onlineAuthor Commented:
tnx for answering my Q.
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.

All Courses

From novice to tech pro — start learning today.