Answered

Getting time diff between 2 times that cross midnight

(0) Share

Report

Posted on by LKMead

Im wanting to find the total minutes between start and finish times (data in 24hr format) using time values only. If start/finish are both before midnight DateDiff Function works fine. However when Finish time is past midnight the calculated value is incorrect.

E.g. Start time 23:03 and finish is 00:03

Im using a If statement to separate which argument is required. Just needing a formula to help me get the correct value in minutes

Cheers!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

EddieE 4,641 Moderator on at

Like (0)

Report

@LKMead
I helped someone with something similar the other day, here

https://powerusers.microsoft.com/t5/Building-Power-Apps/Problem-with-DateDiff/m-p/1471378#M381478

Essentially, your IF() statement checks if your Start Hour > Finish Hour. If so, add 1440 minutes to the DateDiff calc, else add 0.

Was this reply helpful? Yes No
LKMead 14 on at

Like (0)

Report

This Solution worked Thanks!

Was this reply helpful? Yes No