Skip to Content
0
Former Member
Jun 22, 2016 at 06:57 PM

I want to calculate the difference between 2 dates in hours and minutes

141 Views

Hi Everyone,

I want to show the difference between 2 fields in hours and minutes.

I have tried using Date Diff function but it is showing only date in hours.

DateDiff("hour",Datedown,Createdate)

Date down: 5/31/2016 2:58:33 PM and Create Date is 5/31/2016 6:00:44 i am getting result as 4 hours i need in hours and minutes like 4.23(hours.minutes).

I have tried using Date Diff function but it is showing only hours data.

DateDiff("hour",Datedown,Createdate)

Is there any function where i can achieve the result?

Thanks,

Kiran