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
Solved! Go to Solution.
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))
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))
@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
(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
User | Count |
---|---|
133 | |
132 | |
95 | |
75 | |
74 |
User | Count |
---|---|
206 | |
195 | |
70 | |
60 | |
52 |