Lapsed Time

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

 

[Marshall Barton]

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

You can use a text box expression like:

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

 

[Timothy Millar]

Marshall - Thank you so very much. It works perfectly.