Solved: Multiply Duration by a number - Page 2

Plantenance_Lan · 05-14-2019 06:21 AM

Hi!

I would like to multiply the duration (hours) by a number ( by employee), but when I do the expression, there is always a message saying I can’t multiply a number by a duration.

I would like to keep the Duration writing. Exemply 6:30:00 * 3 = 19:30:00

Somebody have a solution?

Thanks!

LeventK

@Plantenance_Landscap
I believe this might help in the AppFormula of your result/calculation column. The result type is: Duration

CONCATENATE(
	HOUR([Duration]-"000:00:00") * [EmployeeNumber] + FLOOR((MINUTE([Duration]-"000:00:00") * [EmployeeNumber] - MOD(MINUTE([Duration]-"000:00:00") * [EmployeeNumber],60))/60) + FLOOR((SECOND([Duration]-"000:00:00") * [EmployeeNumber] - MOD(SECOND([Duration]-"000:00:00") * [EmployeeNumber],3600))/3600),
	":",
	RIGHT("0"&MOD(MINUTE([Duration]-"000:00:00") * [EmployeeNumber] + FLOOR((SECOND([Duration]-"000:00:00")*[EmployeeNumber] - MOD(SECOND([Duration]-"000:00:00") * [EmployeeNumber],60))/60),60),2),
	":",
	RIGHT("0"&MOD(SECOND([Duration]-"000:00:00") * [EmployeeNumber],60),2)
)

View solution in original post