Hello,
I want to find the difference between two dates in hours and minutes.
Reported Date: 1/7/2009 3:10:13 PM
Resolved Date: 1/7/2009 3:40:50 PM
I used the below formula
DateDiff ("h", {HPD_Help_Desk.Reported_Date}, {HPD_Help_Desk.Last_Resolved_Date})
It returns 0.00
I want the output as 0:30 and also in a number value so that I do an average of total time.
Please assist. Thank you so much
I want to find the difference between two dates in hours and minutes.
Reported Date: 1/7/2009 3:10:13 PM
Resolved Date: 1/7/2009 3:40:50 PM
I used the below formula
DateDiff ("h", {HPD_Help_Desk.Reported_Date}, {HPD_Help_Desk.Last_Resolved_Date})
It returns 0.00
I want the output as 0:30 and also in a number value so that I do an average of total time.
Please assist. Thank you so much