How to format time

[puuts]

Hello,

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

SqlQuery = "SELECT DateDiff('n', d_Assigned,c_Date) AS Time_Diff FROM tbl_List WHERE List_ID=" & ListID & ""
                
                                                With rs
                                
                                                        .Open SqlQuery, conn
                            
                                                        
                                                End With
       
       
                                MsgBox (rs.Fields("Time_Diff").Value)

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:

d_Assigned = 02/17/2015 07:30:00 PM
c_Date = 02/17/2015 08:00:00 PM

Time_Diff = 00:30:00 PM

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


Thanks in advance gurus!

[BattleCat]

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

and

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