Get run time from date time stamps
in [Queries]
|
From: GWB on 15 Apr 2010 17:18 I need to get run time in minutes from between a series of date/time stamps. I have no clue of how to do this.. any help would be greatly appreciated
From: John W. Vinson on 15 Apr 2010 18:56 On Thu, 15 Apr 2010 14:18:04 -0700, GWB <GWB(a)discussions.microsoft.com> wrote: >I need to get run time in minutes from between a series of date/time stamps. >I have no clue of how to do this.. any help would be greatly appreciated Probably by using the DateDiff() function: DateDiff("n", [StartTime], [EndTime]) will calculate the difference in time in miNutes ("m" is Months). It's not clear from your post what kind of "series" this is; feel free to post some description of your table structure if you need more help. -- John W. Vinson [MVP]
From: Marshall Barton on 15 Apr 2010 18:58 GWB wrote: >I need to get run time in minutes from between a series of date/time stamps. >I have no clue of how to do this.. any help would be greatly appreciated Not sure what you mean by "run time", but try using: DateDiff("n", starttime, endtime) -- Marsh MVP [MS Access]
From: KARL DEWEY on 15 Apr 2010 19:16 Try this -- SELECT [YourTable].[DateField], DateDiff("n", [YourTable].[DateField], (SELECT TOP 1 [XX].[DateField] FROM YourTable AS [XX] WHERE [YourTable].[DateField] > [XX].[DateField] ORDER BY [XX].[DateField] DESC)) AS Run_Time FROM YourTable ORDER BY [YourTable].[DateField]; -- Build a little, test a little. "GWB" wrote: > I need to get run time in minutes from between a series of date/time stamps. > I have no clue of how to do this.. any help would be greatly appreciated >
From: GWB on 15 Apr 2010 21:33
"Marshall Barton" wrote: > GWB wrote: > > >I need to get run time in minutes from between a series of date/time stamps. > >I have no clue of how to do this.. any help would be greatly appreciated > > > Not sure what you mean by "run time", but try using: > DateDiff("n", starttime, endtime) > > -- > Marsh > MVP [MS Access] > . > Thank you all |