cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Highlighted
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
Highlighted
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
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,464)