Calculate total time spent

(1) Share

Report

Posted on by venka91

1,119

Dear team,

wanted to ask how can i effectively use date and time fuction to calculate the difference between the below.

The start and end time as below. and i would like to show 0 days 1 hour 59 mins spent.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Amol-Kavnekar 125 on at

Like (1)

Report
Copy link

Link copied!
Hi @venka91 ,
You can try this
With(
{
varTotalMinutes: DateDiff(StartDateTime, EndDateTime, Minutes),
varDays: Floor(DateDiff(StartDateTime, EndDateTime, Minutes) / 1440),
varHours: Floor(Mod(DateDiff(StartDateTime, EndDateTime, Minutes), 1440) / 60),
varMinutes: Mod(DateDiff(StartDateTime, EndDateTime, Minutes), 60)
},
Concatenate(varDays, " days ", varHours, " hour ", varMinutes, " mins spent")
)
--------------
If you this solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
venka91 1,119 on at

Like (1)

Report
Copy link

Link copied!

Sorry, Powerapps says there is no floor function. i could find it in help section as well. Can you help

Was this reply helpful? Yes No

Amol-Kavnekar

125 on at

Like (1)

Report

Copy link

Link copied!

You can try this.

With(
{
varTotalMinutes: DateDiff(StartDateTime, EndDateTime, Minutes),
varDays: DateDiff(StartDateTime, EndDateTime, Minutes) \ 1440,
varHours: (DateDiff(StartDateTime, EndDateTime, Minutes) Mod 1440) \ 60,
varMinutes: DateDiff(StartDateTime, EndDateTime, Minutes) Mod 60
},
Concatenate(varDays, " days ", varHours, " hour ", varMinutes, " mins spent")
)

Regards

Amol Kavnekar

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

Was this reply helpful? Yes No

mmbr1606 14,629 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
hey @venka91

can u try this:

"0 days " & Text(DateDiff(DateTimeValue(TextInput_StartTime.Text), DateTimeValue(TextInput_EndTime.Text), Hours), "[$-en-US]0") & " hours " & Text(DateDiff(DateTimeValue(TextInput_StartTime.Text), DateTimeValue(TextInput_EndTime.Text), Minutes) Mod 60, "[$-en-US]0") & " mins"

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
rzuber 552 Moderator on at

Like (1)

Report
Copy link

Link copied!

Try RoundDown() instead
Int, Round, RoundDown, RoundUp, and Trunc functions - Power Platform | Microsoft Learn

Was this reply helpful? Yes No
Verified answer

venka91 1,119 on at

Like (1)

Report
Copy link

Link copied!
This formula worked. But the MOD function must be on front instead of at the end. Not sure if you have tried this formula in excel as the above format of formula did not work. Changing as below worked for me.

Thank you.

With( { varTotalMinutes: DateDiff(StartDateTime, EndDateTime, Minutes), varDays: DateDiff(StartDateTime, EndDateTime, Minutes) / 1440, varHours: Mod(DateDiff(StartDateTime, EndDateTime, Minutes), 1440) / 60, varMinutes: Mod(DateDiff(StartDateTime, EndDateTime, Minutes), 60) }, Concatenate(varDays, " days ", varHours, " hour ", varMinutes, " mins spent") )

Was this reply helpful? Yes No