how do i get the time difference that will output in this format?

00Day 00Hrs 00Min 00Sec

i am not sure if datediff can combine all three. i've tried doing datediff in days,hrs,mins,secs separately then create another formula to combine all four,but apparently the logic is wrong since if timeStart is 10:45AM and timeEnd is 1100AM, it will give me 0Day 1Hr 45Min, which is really wrong.  Anyone have any ideas? Your help will be very much appreciated!Thanks in advance!

hey thanks! it worked , but i made a few changes in the formula. i'll include it here for the others.

local numbervar sec:=datediff("s",{ORD_SPL.OS_SPL_RCVDT},{ORD_DTL.OD_VALIDATE_ON});
local numbervar day:=0;
local numbervar hr:=0;
local numbervar min:=0;
local numbervar calc;

calc:=truncate(sec/(24*3600));
day:=calc;

calc:=truncate(sec/3600);
hr:=calc;

calc:=truncate(sec/60);
min:=calc;

sec:=sec mod 60;
 
totext(day)+"Day "+totext(hr) +"Hrs "+totext(min)+"Min "+totext(sec)+"Sec"

in the formula you gave in the previous post , i would just like to know, what does this do totext(day,0"")? i removed the 0"" in the revision i made bec. it will give an error when i execute the formula.

thanks!