Jornada (CH) SQL

CONVERT(varchar(max), PFUNC.JORNADAMENSAL / 60) + ':' + CASE

WHEN LEN(CONVERT(varchar(max), PFUNC.JORNADAMENSAL % 60)) = 1

THEN '0' + CONVERT(varchar(max), PFUNC.JORNADAMENSAL % 60)

ELSE CONVERT(varchar(max), PFUNC.JORNADAMENSAL % 60)

END AS JORNADAMENSAL,

PFUNC.JORNADAMENSAL/60 AS JORNADA_MENSAL,

(PFUNC.JORNADAMENSAL/60) / 5 AS JORNADA_SEMANAL,

(PFUNC.JORNADAMENSAL/60) / 5 / 8 AS JORNADA_DIAS_SEMANA,