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!

Adding time values in a Report

Status
Not open for further replies.

L0NGH0RN

Technical User
Jul 5, 2006
2
0
0
US
Hi,
I have created a small downtime database in my plant. We would like to track downtime in hours and minutes. Could you direct me in the proper way to do this? I have made a few databases and have had very few problems, but I can't seem to get my brain around adding time values without using 100ths. Any help would be much appreciated!
 
Use DateTime fields to record time-down and time-up. Then take a look at DateAdd and DateDiff functions for ways of retunring the difference between two dates in a meaningful way.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top