Divide time by whole number

[NicoHa]

hey there,

I want a measure that divides time by whole number, and get the result as time.

The first column (data type time) should be divided by the second colum (data type whole number).

The result should be date type 'time'.

thanks in advance!

[NicoHa]

That works, thank you

[Anonymous · Accepted solution]

hello,

create this new column.

newColumn =

VAR seconds = 
HOUR(Table[Aantal uren mw + omk]) * 60 * 60 + MINUTE(Table[Aantal uren mw + omk])* 60 + SECOND(Table[Aantal uren mw + omk])

VAR divided = seconds / Table[Aantal stuks]

RETURN
TIME(0, 0, divided)