cancel
Showing results for
Did you mean:
Highlighted
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.

Regards,

Nabeel

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III

## 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))`

3 REPLIES 3
Highlighted
Super User III

## 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))`

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

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

Regards,

Nabeel

Spoiler
` `

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

Regards,

Nabeel

Spoiler

` `

Announcements

#### Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

#### Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

#### Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,760)