How can I convert Labor Clock In Time to 12hr format

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}

image

to give you:

image

4 Likes