Lapsed Time

  • Thread starter Thread starter Timothy Millar
  • Start date Start date
T

Timothy Millar

I am a little new so please be patient with me. :-)

I need to list in a report the lapsed time from a Date/Time field and Now()
in HH:MM format. For example;

Called In: 09/28/2008 13:05:00
LAPSED TIME: 48:54

Thank you.
 
Timothy said:
I am a little new so please be patient with me. :-)

I need to list in a report the lapsed time from a Date/Time field and Now()
in HH:MM format. For example;

Called In: 09/28/2008 13:05:00
LAPSED TIME: 48:54
Click to expand...


You can use a text box expression like:

=DateDiff("n", thefield, Now()) \ 60 & ":" &
Format(DateDiff("n", thefield, Now()) Mod 60, "00")
 
Back
Top