Unanswered

Timesheet

(0) Share

Report

Posted on by Matt383

407

Hi, working on a timesheet app. I have a start and finish time dropdown and a AM/PM drop down box. I have a hidden label that i want to show army time of what the user selected. On the text properties of the hidden lablel, i can put in the below and it works fine.

If(MonFinish.Selected.Value="12:15"&MonAMPM.Selected.Value,"AM","1215")

But i need to be able to convert all times selected. If i put in the hidden label text properties, see below, i get an error. I have tried Or and && but only shows true and false in the label instead of the time e.g. 1215

If(MonFinish.Selected.Value="12:15"&MonAMPM.Selected.Value,"AM","1215");

If(MonFinish.Selected.Value="12:30"&MonAMPM.Selected.Value,"AM","1230")

Can you please assist

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 154,534 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Matt383 ,

Firstly you need && instead of &, but there may be an easier way depending on what your rules for AM/PM are - the below will get the format

Substitute( MonFinish.Selected.Value, ":", "" )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Matt383 407 on at

Like (0)

Report
Copy link

Link copied!

Hi Warren, yes i did try both && and Or but both result in the label saying false. It works fine if i only have one line. e.g. Substitute( MonStart.Selected.Value, "12:15", "1215")

Was this reply helpful? Yes No
WarrenBelz 154,534 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Matt383 ,

It can be done with a bit of complexity if I knew your AM/PM rules and the conversion result.

Was this reply helpful? Yes No