cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

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

Highlighted
Helper II
Helper II

Re: How to add half an hour to time

@timl

 

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

 

Works perfectly...

New Member

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
Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (1,233)