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.
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
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
Helmut