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 : 1dXE27uHgZBCj/PzJnhw31
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:
I have the same question (0)
  • 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 892 Most Valuable Professional

#2
Power Apps 1919 Profile Picture

Power Apps 1919 356

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 310 Super User 2025 Season 2

Last 30 days Overall leaderboard
Loading complete