web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : e6gYZhBFRdL4edAmueCB8n
Power Apps - Building Power Apps
Answered

Calculate Duration between two times

Like (0) ShareShare
ReportReport
Posted on 21 Feb 2019 06:09:35 by 108

Hello all powerapps users,

 

I have four dropdowns, which store hour and minutes, two dropdown for start time and two dropdown for end time.

I want to calculate time duration between two times.

 

please provide how can i calculate time difference.

 

Note: Time Calculate for only single date.

 

error.jpg

 

 

 

Thanks

 

Categories:
  • Verified answer
    AndySid Profile Picture
    165 on 21 Feb 2019 at 07:03:04
    Re: Calculate Duration between two times

    Hi, 

    I use this formula, using 24 hour dropdowns...

    Took me a while to sort when I did but works well.

     

    Text(((HourValue12_2.Selected.Value*60+MinuteValue12_2.Selected.Value)-( HourValue11_2.Selected.Value*60+MinuteValue11_2.Selected.Value))/60,"[$-en-US]###.00")

    Hope this helps....

     

    >>If you found this reply helpful, please mark this as the answer to close the topic and make it easier to find for other people with similar questions.<<

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2