How to calculate the Time Difference between two dates

[walt]

Hello,
I have been trying to calculate the difference between two date and display the difference in hours and minutes (HH:MM). I can't get it calculate properly and I can't hours and minutes to display.

I tried "results=enddate-startdate" dates have month, day, year,and time of day. After this calculation I end up with no results.
Any help would be appreciated.

Walt

[ADezii]

Hello,
I have been trying to calculate the difference between two date and display the difference in hours and minutes (HH:MM). I can't get it calculate properly and I can't hours and minutes to display.

I tried "results=enddate-startdate" dates have month, day, year,and time of day. After this calculation I end up with no results.
Any help would be appreciated.

Walt

I'll illustrate 1 Method by code:

Dim dteStartDateTime As Date, dteEndDateTime As Date
dteStartDateTime = #5/20/2007 7:00:00 AM#
dteEndDateTime = #5/20/2007 11:15:00 AM#
 
Debug.Print "Difference in Hours: " & DateDiff("h", dteStartDateTime, dteEndDateTime)
Debug.Print "Difference in Minutes: " & DateDiff("n", dteStartDateTime, dteEndDateTime) - _
            (DateDiff("h", dteStartDateTime, dteEndDateTime) * 60)

OUTPUT:

Difference in Hours: 4
Difference in Minutes: 15

[walt]

Adezii,
Thanks for the tip! I tried it and it works but my problem is combining the hours and minutes (HH:NN) in records. ex: 4:05, 12:14, etc
I tried to divide the total minutes by 60 but I don't get a remainer. The application is, the time is entered in severalrecords for a job, then I want to be able to sum the hours and minutes from the records and get total time (hours:minutes) for the job.
Thank again

I'll illustrate 1 Method by code:

Dim dteStartDateTime As Date, dteEndDateTime As Date
dteStartDateTime = #5/20/2007 7:00:00 AM#
dteEndDateTime = #5/20/2007 11:15:00 AM#
 
Debug.Print "Difference in Hours: " & DateDiff("h", dteStartDateTime, dteEndDateTime)
Debug.Print "Difference in Minutes: " & DateDiff("n", dteStartDateTime, dteEndDateTime) - _
            (DateDiff("h", dteStartDateTime, dteEndDateTime) * 60)

OUTPUT:

Difference in Hours: 4
Difference in Minutes: 15

[missinglinq]

So after calculating the two, you need to concatenate them:

TimeDifference =  [Difference in Hours] & ":" & [Difference in Minutes]

[ADezii]

Adezii,
Thanks for the tip! I tried it and it works but my problem is combining the hours and minutes (HH:NN) in records. ex: 4:05, 12:14, etc
I tried to divide the total minutes by 60 but I don't get a remainer. The application is, the time is entered in severalrecords for a job, then I want to be able to sum the hours and minutes from the records and get total time (hours:minutes) for the job.
Thank again

1. missingling has the correct response about concatenating both differences.
2. Look at the code again, you are not dividing by 60. To get the Minutes component you are calculating the total number of minutes difference - (minus) the number of Hours difference * 60.

[sansaniwal]

1. missingling has the correct response about concatenating both differences.
2. Look at the code again, you are not dividing by 60. To get the Minutes component you are calculating the total number of minutes difference - (minus) the number of Hours difference * 60.

Query will be like as :------------
db2 "select substr(HOSTNAME,1,25) as hostname,ltrim(rtrim(char(timestampdiff(8,char(tim estamp(CLOSETIME)-timestamp(STARTTIME)))))) ||':' || char((int(
ltrim(rtrim(char(timestampdiff(4,char(timestamp(CL OSETIME)-timestamp(STARTTIME))))))))- ( int( ltrim(rtrim(char(timestampdiff(8,char
(timestamp(CLOSETIME)-timestamp(STARTTIME)))))))*60)) as difftime from EVENTS_TIME"

[satiss7pwr]

plese will u post this code in c# plssssssssssssssssss

[ADezii]

This sounds like a question for the C# Forum, not here.