218 posts tagged with "Power Apps"

A shift from 22:00 to 06:00 lasts eight hours, but on one day's clock 06:00 comes before 22:00, so a plain subtraction goes negative. When the finish time is earlier than the start, put it on the next day, then count the minutes between the two moments.

DateDiff measures the time between two dates or times, as a whole number of the unit you ask for. Ask in hours, and 17:00 to 20:30 is 3: the half hour is lost. Ask in minutes, get 210, and divide by 60 for 3.5 hours.

DateAdd adds an amount of time to a date or a date and time: a day, a few hours, 450 minutes. Give it a negative number to go back instead. It's how a timesheet moves a finish time onto the next day.

A date picker gives you a date, a time picker a time; many things need both, as one moment. DateTime builds it from the parts: DateTime(Year(d), Month(d), Day(d), Hour(t), Minute(t), 0) is time t on day d.

Hour and Minute take a time apart. For 22:30 they return 22 and 30, as numbers. Hour always counts on the 24-hour clock, from 0 to 23, whatever format the time is shown in.

Year, Month and Day take a date apart. For 8 November 2026 they return 2026, 11 and 8, as numbers, ready to build another date or time from the same day.

For a number, such as a quantity or a break in minutes, use the modern Number input. It has up and down buttons, keeps the number between Min and Max, and moves by Step. Formulas read the number from Value, which changes when the person leaves the box.

The modern Power Apps controls include a Date picker but no time picker. A modern Combobox that lists every time of day does the job: people scroll to a time or type a few digits, such as 22, to narrow the list, and formulas read the chosen Time from Selected.

ForAll runs a formula once for every record of a table and returns a new table of the results, in the same order. Give it Sequence's numbers, and it can build a whole list in one formula: here, every time of day, five minutes apart, for a drop-down.

Sequence makes a table of numbers. Sequence(5) gives 1, 2, 3, 4 and 5; give it a start and a step, and Sequence(288, 0, 5) counts every five minutes of a day, from 0 to 1,435. Together with ForAll, it builds lists such as every time of day for a drop-down.