Subtract minutes from dropdown result - 14:00 - 20 mins to display 13:40

(0) Share

Report

Posted on by Matt_G0101

Good morning all,

I'm a new user to Power apps, it's an amazing tool. I need a little help with a project I'm working on.

Basically I would like to use data from two drop down boxes ( Hours ) & (Minutes) & display as time in a separate box called (departure time) . Can this be displayed as HH : MM ?

Then I would like to have a series of display boxes that show the time that a task needs to be completed -20 mins before, -30 mins before, -5 mins before & so on until 0 mins would be the same as the original entered departure time.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Matt_G0101 11 on at

Like (0)

Report

So I've managed to get the time to display from my drop down boxes using -
TimeValue('STD Hours'.Selected.Value & ":" & 'STD Minutes'.Selected.Value)

however my code I'm using to display task times shows negative values in the boxes? Is this a format issue with the type of box?

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report
Hi @Matt_G0101 ,

I've made a test for your reference:

1\I assume there is a dropdown control-Dropdown-H

Items

Sequence(24,0,1)

2\I assume there is a dropdown control-Dropdown-M

Items

Sequence(60,0,1)

To get the result:

With( { totalMins:Value('Dropdown-H'.SelectedText.Value)*60+Value('Dropdown-M'.SelectedText.Value), subMins:20 }, Text(RoundDown((totalMins-subMins)/60,0),"00")&":" &Text(Mod((totalMins-subMins),60),"00") )

Best Regards,

Bof

Was this reply helpful? Yes No
Verified answer

Matt_G0101 11 on at

Like (0)

Report

Far out Bof!! you are amazing!!!

With(
{
totalMins:Value('STD Hours'.SelectedText.Value)*60+Value('STD Minutes'.SelectedText.Value),
subMins:20
},
Text(RoundDown((totalMins-subMins)/60,0),"00")&":" &Text(Mod((totalMins-subMins),60),"00")
)

Was this reply helpful? Yes No