Displying the Date difference in Days and hours format.

[Mpotla]

Hi,

I have requirement to display the age of the request raised from Request start and end dates, which are date time fileds.

I am able to calculate the difference using  calculation (Request start - end dates), which is resulting output in the format given below.

18 days 1 hour 27 minutes 57 seconds 746 milliseconds


But my user want to see the output till days and hours only.

Please suggest us, how to remove the minutes ,seconds,milliseconds from the output.

I wil be exporting the data to Excel.


Thanks in Advance.
mc

[colt]

Use Data Format - Time Interval. There you have many options to specify format you need.