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... 🙂

 

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
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,619)