cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
NabeelNQ
Level: Powered On

How to add half an hour to time

Hello Everyone!

 

I wanted to add / subtract 30 minutes from a given time.

 

Every user has a particular check in time, but they need to check in only 30 minutes before or after the actual check in time.

 

All the time values are colledcted from dropdowns.

 

Now I want to display their check in time, so whatever time they select, I should be able to add half an hour to that.

 

Please help me out

 

Regards,

Nabeel

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: How to add half an hour to time

Hi Nabeel,

With PowerApps, you can add values to date/times in units of days.

Say you have a time of 13:15. (In your case, you can replace the hardcoded values with your combobox values)

DateTimeValue(Text(Today() & " " & "13" & ":" & "15"))

To add 30mins, you can use this formula (ie 60*24 = number of minutes in a day)

DateTimeValue(Text(Today() & " " & "13" & ":" & "15")) + (30/(60*24))

 

View solution in original post

3 REPLIES 3
Super User
Super User

Re: How to add half an hour to time

Hi Nabeel,

With PowerApps, you can add values to date/times in units of days.

Say you have a time of 13:15. (In your case, you can replace the hardcoded values with your combobox values)

DateTimeValue(Text(Today() & " " & "13" & ":" & "15"))

To add 30mins, you can use this formula (ie 60*24 = number of minutes in a day)

DateTimeValue(Text(Today() & " " & "13" & ":" & "15")) + (30/(60*24))

 

View solution in original post

NabeelNQ
Level: Powered On

Re: How to add half an hour to time

@timl

 

Thanks a lot! As usual, you saved the day once again... Smiley Happy

 

Works perfectly...

seongkooioh66
Level: Power Up

Re: How to add half an hour to time


@NabeelNQ wrote:

Hello Everyone!

 

I wanted to add / subtract 30 minutes from a given time.

 

Every user has a particular check in time, but they need to check in only 30 minutes before or after the actual check in time.

 

All the time values are colledcted from dropdowns.

 

Now I want to display their check in time, so whatever time they select, I should be able to add half an hour to that.

 

Please help me out

 

Regards,

Nabeel


Spoiler
 
HeartWelcome Scan.jpg


(s)


@NabeelNQ wrote:

Hello Everyone!

 

I wanted to add / subtract 30 minutes from a given time.

 

Every user has a particular check in time, but they need to check in only 30 minutes before or after the actual check in time.

 

All the time values are colledcted from dropdowns.

 

Now I want to display their check in time, so whatever time they select, I should be able to add half an hour to that.

 

Please help me out

 

Regards,

Nabeel


Spoiler
 
 

Man Very Happy<top>skillicon.png

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 342 members 2,887 guests
Please welcome our newest community members: