DateDiff Hours Minutes AND Seconds

(0) Share

Report

Posted on by iwonder

1,142

Thank you for taking the time to read my question.

I'm wondering how to use DateDiff() to calculate the hours, minutes and seconds between the first record in my collection and the last record in my collection.

I found a post to do the hours and minutes which works, but I tried to keep the same format and add seconds but it's not working as expected.

If a few seconds pass, I also get a value for the minutes.

Here is my code... am I close?

If(IsEmpty(colLocHist),"","Travel Time: " & DateDiff(First(colLocHist).CaptureDateTime,Last(colLocHist).CaptureDateTime,Hours) & ":" & If(Len(Text(Mod(DateDiff(First(colLocHist).CaptureDateTime,Last(colLocHist).CaptureDateTime,Minutes),60)))=1,"0"&Mod(DateDiff(First(colLocHist).CaptureDateTime,Last(colLocHist).CaptureDateTime,Minutes),60),Mod(DateDiff(First(colLocHist).CaptureDateTime,Last(colLocHist).CaptureDateTime,Minutes),60))) & ":" & If(Len(Text(Mod(DateDiff(First(colLocHist).CaptureDateTime,Last(colLocHist).CaptureDateTime,Seconds),60)))=1,"0"&Mod(DateDiff(First(colLocHist).CaptureDateTime,Last(colLocHist).CaptureDateTime,Seconds),60),Mod(DateDiff(First(colLocHist).CaptureDateTime,Last(colLocHist).CaptureDateTime,Seconds),60))

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

iwonder 1,142 on at

Like (0)

Report
I just realized I could simplify to this:

If(IsEmpty(colLocHist),"","Travel Time: " & DateDiff(First(colLocHist).CaptureDateTime,Last(colLocHist).CaptureDateTime,Hours) & ":" & Text(Mod(DateDiff(First(colLocHist).CaptureDateTime,Last(colLocHist).CaptureDateTime,Minutes),60),"00") & ":" & Text(Mod(DateDiff(First(colLocHist).CaptureDateTime,Last(colLocHist).CaptureDateTime,Seconds),60),"00")

Was this reply helpful? Yes No
Verified answer

iwonder 1,142 on at

Like (1)

Report
Got it:

If(IsEmpty(colLocHist),"","Travel Time: " & DateDiff(First(colLocHist).CaptureDateTime,Last(colLocHist).CaptureDateTime,Hours) & ":" & Text(Mod(DateDiff(First(colLocHist).CaptureDateTime,Last(colLocHist).CaptureDateTime,Minutes),60),"00") & ":" & Text(Mod(Mod(DateDiff(First(colLocHist).CaptureDateTime,Last(colLocHist).CaptureDateTime,Seconds),60),60),"00"))

Was this reply helpful? Yes No
iwonder 1,142 on at

Like (0)

Report

...Actually I didn't

07/08/2021 16:22:49
07/08/2021 16:23:15

returns: 0:01:26

Do I need to determine total seconds and then calculate back the minutes and hours?

Was this reply helpful? Yes No