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!
Search results for query: *
- Users: grobertson
- Order by date
-
How do you calculate the sum of time periods?
For the addition of time problem, the data type is Short time. Thank you- grobertson
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
How do you calculate the sum of time periods?
I am trying to calculate the sum of several time periods. I found a formula to calculate the difference between two time periods, that formula is Format([StartTime]-1-[EndTime], "Short Time"). The query I am trying to design needs to take the tracked time for a process from each...- grobertson
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
Subtracting number from Date Format in qry
Here's a similar question. What is the formula for finding the total time. Example: Total Time= Time1 + Time 2 I want to do a query that will take the sum of time from Field 1 and Field 2, and display the result in Field 3 of my query. Thank you. grobertson1@msn.com- grobertson
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
