DateDiff hours between date ,hour and minute

[Gorilla_8]

I wanna calculate difference between:

Many days, and the hours and minutes between those days

For example:

12/03/2021 08: 54 until 12/09/2021 16:48

Display the result: 6 days, Hours:Minutes

[rubin_boer]

hi @Gorilla_8 

you can try

With(
    { 
        StartDate:DateTimeValue("12/03/2021 08:54"), //replace the date with yourValue 
        EndDate:DateTimeValue("12/09/2021 16:48") //replace the datestring with yourValue
    },
        DateDiff(StartDate,EndDate) & " days, " & Abs(Hour(EndDate) - Hour(StartDate)) & " hours: " &Abs(Minute(EndDate) - Minute(StartDate)) & " minutes"
)

Hope it helps

R

[Gorilla_8]

@rubin_boer 

Thank you very much for the response, but I need to compare datepicker values with hour and minutes.

[rubin_boer · Accepted solution]

hi @Gorilla_8 noted, as the datepicker don't provide the functionality for hours and minutes consider the following:

Hope it helps,

R

[Gorilla_8]

@rubin_boer 

Thank you very much for the solution!

I was struggling with this!