in MS Access, how do i calculate the time elapsed between 2 times?

Question

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.

Answer 1

Datediff("s", start_time, end_time) would give you the difference in seconds between the to times

Helmut

Answer 2

update table_name set difference = end_time -start_time