Round Up minutes to whole Hour

[Anonymous]

Can I round up the minutes to whole hour?

This is the current formula I have.

Hours worked =

VAR _min =calculate(MIN('TNS_dbo_POS.CPI'[Time]),ALLEXCEPT('TNS_dbo_POS.CPI','TNS_dbo_POS.CPI'[BUS_DATE],'TNS_dbo_POS.CPI'[EMP_ID]))

VAR _max = CALCULATE(MAX('TNS_dbo_POS.CPI'[Time]),ALLEXCEPT('TNS_dbo_POS.CPI','TNS_dbo_POS.CPI'[BUS_DATE],'TNS_dbo_POS.CPI'[EMP_ID]))

RETURN

FORMAT(_max -_min, "h")

[aj1973 · Accepted solution]

Hi @Anonymous 

this column 'TNS_dbo_POS.CPI'[Time] contains HH:MM:SS ? if so then you need to render it all in SS then 

Hours worked = 

VAR _Hours = DIVIDE('TNS_dbo_POS.CPI'[Time_In_Seconds] ,3600)
RETURN

ROUNDUP(_Hours, 0)