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

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

2
2006-08-12 03:10:48, Category: Programming & Design
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.

Answers

  1. TRAXIC

    On 2006-08-12 03:13:12


    update table_name set difference = end_time -start_time

  2. hswes

    On 2006-08-12 03:13:45


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