Need logic help to calculate time in Days,Hours,Minutes and seconds.

[lalitkgehlot89]

Hi,

In Attached file need help to calculate DownTime from [Created Date Time] & [Closed Date Time] in Days,Hours,Minutes & seconds.

Downtime = [Closed Date Time] - [Created Date Time]

thanks

Lalit Kumar

[swuehl]

Maybe using Interval() function:

=Interval( [Closed Date Time] - [Created Date Time], 'd hh:mm:ss')