I have a need to find the elapsed time between two datetime fields. I need to find the downtime between the end of one job {incendent.timeinservice}to the start of another job {incendent.timealerted} for each truck {incendent.unitid}. Each job(incendent.id)has it's on entry into the database. The times might span from late one night to early the next morning or be within the same day.I ony need the hours and minutes of, or just minutes of downtime. Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Help for unique elapsed time
- Thread starter Phillipg
- Start date
synapsevampire
Programmer
Use the datediff function.
You can set it to 'n' for minutes, divide by 60 for hours, then use a remainder using 60 to determine the minutes.
-k kai@informeddatadecisions.com
You can set it to 'n' for minutes, divide by 60 for hours, then use a remainder using 60 to determine the minutes.
-k kai@informeddatadecisions.com
- Thread starter
- #3
faq149-243 has a formula to convert your value into an elapsed time string, if you need to format it. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question