Hi,

I have a table that logs a datetime every a machine starts or stops. I need to find the total downtime (stop time - start time). I'm looping through the table to get this, but I'm not sure how to convert the datetime into only time.
example: I need it to be 48:22:11 instead of 1/2/1900 22:11.

Thanks for any help,

Dave

Hi,

   I would play around with something like:

Dim dtDate As Long

dtDate = Now()

This yields the number of seconds since the starting date for date stamps, which I forget what that is. I could look it up in the Wrox collection. Anyway, you might then convert that number into the format that you want based on the proper arithmetic.

I know there is an easier way to do this in SQL Server, especially, but don't have access to the collection right now.

Play around with vbscript and echoing the value and see if you get any ideas. I will look around later if you are still stumped.

Did that help?


mmcdonal

Convert(Varchar,CompletedDT,108) Would put the DT info into your 48:22:11 example

I also have two several machines where I compute differences between start and stop time which are returned to me by sql in the form of datetime, but I render the results to the user in hours. Here is how I do it:


Format$(DateDif"n",View_PdateLiveLines.FirstLayerD T,View_PdateLiveLines.LastLayerDT)/60,"##.0")),"") AS TotalRunningHours

This just uses the DateDiff function and returns the difference between start and stop time in minutes "n". Then, I divide by 60 to put it in hours and throw a formate around the whole thing in numeric decimals.

Let me know if this helps, I could look into some other areas of my code where I have done other similar functions.

Coby.

Thanks guys.

I'm gonna try some of your suggestions and see what I come up with.