Answered

How to add time to an existing time?

(0) Share

Report

Posted on by r_voyager

130

Hi All,

I have a label in which I have time value : 1:00 AM
Code: " Text(DateTimeValue(Dropdown2.SelectedText.Value),DateTimeFormat.ShortTime) "

Now I want to add time to this Label so it becomes 4:30 AM

I have tried dateadd function but it is giving me error.
code: " Text(DateTimeValue(Label),DateTimeFormat.ShortTime) +Text(DateAdd(DateTimeValue(Label),3,Hours),DateTimeFormat.ShortTime) "

Pls help me on this.

Regards,
Rahul

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

RusselThomas 4,014 on at

Like (1)

Report
Copy link

Link copied!
Hi @r_voyager ,
I'm guessing you're trying to add time to text instead of adding time to datetime. It might help to confirm this by stating what error you're getting and where you're getting it? Date functions generally only work with Date types and here it looks like you're adding Text + Text.
Try this to start on a label Text: property;
Text(DateAdd(DateTimeValue(Dropdown2.SelectedText.Value),3,Hours),DateTimeFormat.ShortTime)
Kind regards,
RT

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @r_voyagerm,

Have you solved your problem?

Do you want to format the existing time as 3.5 hours later?

Modify your formula as below:

Text(DateAdd(DateAdd(DateTimeValue(Label47.Text),30,Minutes),3,Hours),"hh:mm am/pm")

Was this reply helpful? Yes No
r_voyager 130 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the reply and Yes I solved my problem in same way you showed.

Regards,
Rahul

Was this reply helpful? Yes No