Hi,

I have the following formula:

datediff ("d",  {@Open Time}, {@Close Time})
&":"& datediff ("h",  {@Open Time}, {@Close Time}) MOD 24
&":"& datediff ("n",  {@Open Time}, {@Close Time}) MOD 60

when i run this formula I am getting values in the following format:

10.00:23.00:34.00

I want to eliminate the .00 values from the number and look like this:

10:23:34

if possible can you add  and make it like this:

10d:23h:34m

Please help.

Hi thanks a lot. The formula is working fine.

But I have one problem:

{@Open Time}:5/5/09 11:38 PM
{@Close Time}:5/6/09 06:12 PM

I get 1d:19h:27m

actually it should be 18h:27m

I dont know why it's coming 1d and 1h ahead.

can you please help me.

Hi,

When I ran the formula I am getting the following:

0d:00

Can you please help.