QA.TechInterviews.com - your tech questions answered
In MS Access, How Do I Calculate The Time Elapsed Between 2 Times?
how do i calculate the time elapsed between 2 times?
I have a field start_time and end_time, and i want to calculate the time between those and store that in another field.
Datediff("s", start_time, end_time) would give you the difference in seconds between the to times

Helmut
update table_name set difference = end_time -start_time
Datediff("s", start_time, end_time) would give you the difference in seconds between the to times

Helmut

Back to QA. TechInterviews.com. Powered by Yahoo! Answers and TechInterviews.com community.