HourHour(“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.