substracting two 'Now()' timestamps

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Guys,

Im trying to find out how to substract two timestamps into the format hh:mm:ss.

I currently use this formula wich gives me the timedifference but only in minutes:

timediff = DateDiff(
 TimeValue(startTime),
 TimeValue(endTime),
 Minutes

Kind regards,

Anthony

Categories:

Building Power Apps

All responses (8)

Answers (1)

Sort by

WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Assuming the code posted produces the minutes total you want, try this

With( { wMinutes: DateDiff( TimeValue(startTime), TimeValue(endTime), Minutes ) }, RoundDown( wMinutes / 60, 0 ) & ":" & Mod( wMinutes, 60 ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

hi @WarrenBelz

Im trying to get the timedifference in format hh:mm:ss or hh:mm would be good aswell.

Greetings,

Anthony
Verified answer

rizkyaditya 292 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @Anonymous ,

You can try this if you want to show the result from your timediff represented in hh:mm:ss
Text(Time(0,0,DateDiff(TimeValue(startTime), TimeValue(endTime), Seconds)), "hh:mm:ss")

I hope this helps!
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@rizkyaditya

worked like a charm!

thank you very much.
rizkyaditya 292 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Anonymous ,

One small note from me.
That only works if the time difference is UNDER 24 hours.

Because if it is more than that, the hour reading will not be accurate.
But if in your case the time difference only ranging in minutes and under 24 hours, than that will be your solution.
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

@rizkyaditya ,

In my case the timedif will never be over 24 hours so great solution 😄

greetings,

Anthony
WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@rizkyaditya ,

You might give me the chance to answer the question (which had already addressed the initial post)
rizkyaditya 292 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Mr. @WarrenBelz ,

I apologize for the overlapping of my reply with yours.
I believe my browser window didn't refresh properly when i opened this thread and leave it sometime before i replied it yesterday.