HOUR
HOUR([Date])Syntax
HOUR(date expression)
Date grouping function which returns the date truncating minutes of the expression.
date expression: Date calculation created using date functions, data fields or constants.
Use cases
Spent time on tasks grouped by hour
Compare the sum of spent hours for completed tasks.
Source: Tasks
Time tracking stats for tasks of the building super hero suit
| Completed On | Task | Hours Spent | Feature |
|---|---|---|---|
| 03 Jan 2018 10:13 AM | Create a steel helmet to protect head | 19 | Protective Suit |
| 20 Jan 2018 04:08 PM | Create a chest protection from steel | 45 | Protective Suit |
| 05 Feb 2018 11:34 AM | Ask agency to create fancy identity for new super hero | 30 | Design |
| 09 Feb 2018 02:11 PM | Install super hero logo on body and helmet | 2 | Protective Suit |
| 09 Feb 2018 02:11 PM | Put on gloves with nice color | 2 | Protective Suit |
| 12 Feb 2018 09:01 PM | Ask Hulk to push in head | 5 | Combat Testing |
| 01 Mar 2018 06:45 PM | Ask Hulk to push in chest | 5 | Combat Testing |
Chart SCATTERPLOT
Y: SUM([Hours Spent])
X: HOUR([Completed On])
LABEL: HOUR([Completed On])
| HOUR(Completed On) | SUM(Hours Spent) |
|---|---|
| 3-Jan-2018 10:00 | 19 |
| 20-Jan-2018 16:00 | 45 |
| 5-Feb-2018 11:00 | 30 |
| 9-Feb-2018 14:00 | 4 |
| 12-Feb-2018 21:00 | 5 |
| 1-Mar-2018 18:00 | 5 |