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,