Power Fx function
Time — Power Fx function reference
Build a time from parts.
Syntax
powerfx
Time( Hour, Minute, Second [, Millisecond ] )
Examples
powerfx
Time(9, 30, 0)
→ A time
powerfx
Time(14, 30, 0)
powerfx
Text(Time(9, 5, 0), "h:mm AM/PM")
Common mistakes & gotchas
- Time() returns a time-only value anchored to an implicit reference date — arithmetic or comparisons against a full DateTime column can behave unexpectedly unless you extract just the time portion from the other side too.
- Hour uses 24-hour values (0–23) regardless of display format; 12-hour AM/PM only appears when rendered with Text().
Related Power Fx functions
From Date & time