A calculated field.
edit
A calc filed of type Datetime, with the expression
convert(datetime, Clockin/24)
converts it to a datetime. Then in the format of the displayed columns, select {time}
to give you:
A calculated field.
A calc filed of type Datetime, with the expression
convert(datetime, Clockin/24)
converts it to a datetime. Then in the format of the displayed columns, select {time}
to give you: