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

All responses (3)

Answers (1)

Sort by

RusselThomas 4,014 on at

Like
a
(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
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(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")
r_voyager 130 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Regards,
Rahul