web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Calculating Total Time...

Power Apps

Answered

Calculating Total Time From Two ComboBoxes

(0) Share

Report

Report

Posted on by MH3

1,059

Hi,

I have two Combo Boxes, Names: TimeOffFrom, TimeOffTo

In which user will Select a value from the two Combobox (dropdowns), after that I want to show the total time requested in a Label,

I have values like this:
Combobox1 : 9:00 AM, 9:30 AM, ....,12:00 PM,.. 5:00 PM

Combobox2 : 9:00 AM, 9:30 AM, ....,12:00 PM,.. 5:00 PM

I want to show in the Label like this:
2 - Hours, 3 - Hours etc

Check ScreenShots

Label should show : 1 - Hour as from 10:00 AM to 11:00 AM

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

mdevaney 29,991 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@MH3
I assume your ComboBox values are text strings rather than actual time objects. Please use this code in the Text property of a label to display the hours difference.

DateDiff(TimeValue(ComboBox1.Selected.Value), imeValue(ComboBox2.Selected.Value), Hours)

If your ComboBox values are actual Time objects you can use this shorter code.

DateDiff(ComboBox1.Selected.Value, ComboBox2.Selected.Value, Hours)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
MH3 1,059 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mdevaney ,

The formula worked, but there are some issues, it works when I select 1 hour difference between the two times.
but when I select like this, check ScreenShots

1) Scenario It should show 3:30 Hours

2) Scenario it should show 00:30 Hours

The Minute difference is not shown here, how to fix your code according to this?

Was this reply helpful? Yes No

Join the conversation