web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Round time to nearest ...

Power Apps

Answered

Round time to nearest 15 minute in a text box

(0) Share

Report

Report

Posted on by I_Mo

Hi,

I just want to display by default in a text box the current time but rounded up to the nearest 15 minute:

e.g. 12:15

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (2)

Sort by

Verified answer

EddieE 4,641 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@I_Mo

Try this

Text( DateAdd( Now(), 15-Mod(Minute( Now()), 15), TimeUnit.Minutes), "hh:mm AM/PM")

Was this reply helpful? Yes No
I_Mo on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much for your prompt help @EddieE .

Could I trouble you for one more related help.
I have your above formula in one text box call txtFrom.
How can I create the formula for a second textbox which will take the time from txtFrom and add 30 minutes to it?

Was this reply helpful? Yes No
Verified answer

EddieE 4,641 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@I_Mo

This worked for me

Text( DateAdd( txtFrom, 30, TimeUnit.Minutes), "hh:mm AM/PM")

Was this reply helpful? Yes No

Join the conversation