Interval between two date/time fields 2

[mguidry5]

Simple query: I need to determine the interval (in hours:minutes:seconds) between two date/time fields, StartDate and EndDate.

 

[HitechUser]

mguidry5,

And this would be that....

http://support.microsoft.com/default.aspx?scid=kb;en-us;88657

There you go...

 

[mik18]

NewTime = Format(DateDiff("s",StartDate,EndDate),"hh:nn:ss")

The format part may work though I have never tried it. If not, still use the datediff function to get the time interval in seconds then build that into hours minutes and seconds.

mike

 

[PHV]

If the days are the same:
Interval: Format(EndDate-StartDate,'h:nn:ss')
If not:
Interval: (24*Int(EndDate-StartDate)+Format(EndDate-StartDate,'h')) & Format(EndDate-StartDate,':nn:ss')

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[mguidry5]

PHV - once again, you da man! Thanks for the simple solution.