Formula help

[EagerBeaver]

Please help...

I am substracting datge and time fields and getting the result in a number string...

I need it to display in days, hours, minutes, seconds
format... How do I get it in that format.

Thanks in advance

 

[EagerBeaver]

I have just modified my FAQ in the general forum (formula number 9) to include days. Multiply your number (which should be in days) by 86400 to convert it to total seconds. Then you can use the seconds in the formula.