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 OnTaskHours SpentFeature
03 Jan 2018 10:13 AMCreate a steel helmet to protect head19Protective Suit
20 Jan 2018 04:08 PMCreate a chest protection from steel45Protective Suit
05 Feb 2018 11:34 AMAsk agency to create fancy identity for new super hero30Design
09 Feb 2018 02:11 PMInstall super hero logo on body and helmet2Protective Suit
09 Feb 2018 02:11 PMPut on gloves with nice color2Protective Suit
12 Feb 2018 09:01 PMAsk Hulk to push in head5Combat Testing
01 Mar 2018 06:45 PMAsk Hulk to push in chest5Combat Testing


Y: SUM([Hours Spent])

X: HOUR([Completed On])

LABEL: HOUR([Completed On])


HOUR(Completed On)SUM(Hours Spent)
3-Jan-2018 10:0019
20-Jan-2018 16:0045
5-Feb-2018 11:0030
9-Feb-2018 14:004
12-Feb-2018 21:005
1-Mar-2018 18:005