How to format time

Hello,

I have the below query to compute the Time difference of my two fields: d_Assigned and c_Date

Please Login or Register  to view this content.

d_Assigned and c_Date are both Date/Time (General Date)
while Time_Diff is also Date/Time but in Long Time

What i want is the result should be in this format: 00:00:00

For example:

Please Login or Register  to view this content.

When using the above code, the result I got is only 30


Thanks in advance gurus!

check out this link:
http://stackoverflow.com/questions/2...ime-formatting

and

https://support.office.microsoft.com...rs=en-US&ad=US