I am trying to calculate the difference of 2 date fields, [FRST_TOUCH_TS], and [CRT_TS] . I need the result to look like HH:mm:ss.

## I tried different ways like:

=DaysBetween([FRST_TOUCH_TS] ;[CRT_TS]) * 86400

+

(

ToNumber(FormatDate([CRT_TS] ;“HH”)) * 3600 +

ToNumber(Left(FormatDate([CRT_TS] ;“mm:ss”) ;2)) * 60 +

ToNumber(FormatDate([CRT_TS] ;“ss”))

)

(

ToNumber(FormatDate([FRST_TOUCH_TS] ;“HH”)) * 3600 +

ToNumber(Left(FormatDate([FRST_TOUCH_TS];“mm:ss”) ;2)) * 60 +

ToNumber(FormatDate([FRST_TOUCH_TS] ;“ss”)))

But the formula above only gives me a number (e.g. 0.83)… How do I make the result show in a HH:mm:ss format?

Anyone can help?

Thank you very much in advance.

**dlam20100322** *(BOB member since 2013-05-13)*