Page
|
|
|
Next Page |
|
| Contents > Functions reference (alphabetical list) > Time functions > Hour function |
|
|
| Hour function |
| Format |
Hour(time) |
| Parameter |
| time - any time value or field of type time |
| Data type returned |
| number |
| Description |
| Returns a number representing the number of hours in time. |
| Examples |
| Hour("12:15:23") returns 12. |
| Hour(Duration) + (Minute(Duration)/60) returns 2.5, when the Duration time field contains 2:30:15. |
| If(Hour(HoursWorked) > 8;"Overtime Pay";" ") returns Overtime Pay when the number of hours in HoursWorked is greater than 8. |
| Hour(CheckIn) returns 3 when the value of CheckIn is 3:24. |
| Related topics |
|
Functions reference (category list) |
|
Functions reference (alphabetical list) |
|
About formulas |
|
About functions |
|
Defining calculation fields |
|
Using operators in formulas |
|
|
| Contents > Functions reference (alphabetical list) > Time functions > Hour function |
|
|
Next Page |
|