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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cumulative

Status
Not open for further replies.

ptrifile

Technical User
Aug 10, 2004
457
US
I have a table that has 2 fields...[timestartstamp] and [timeendstamp].

They are fomatted mm-dd hh:nn:ss, my question is, how can I get a cumulative time between the 2 fields.

Thanks for any help

Paul
 
Do you mean the time elapsed between the start and end time???

If so, take a look at the DateDiff function.

DateDiff("nn", [timestartstamp], [timeendstamp])

Should return the number of minutes between the two, "ss" would be seconds, etc.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top