Hey guys.
I’m having a little problem with calculated fields and SharePoint 2013 Workflow.
I’ve a variable named ‘vLondonContractHours‘ and have set it like so;
Set time as 9:0 for Current Item: Created (Output to Variable: vLondonContractHours)
Then I was able to…
Set Daily Contract Hours to Variable: vLondonContractHours
…this gives 09:00 hours which is correct. Now, I want to multiply this by 5 and Update an Item (where the item column is called ‘Weekly Contract Hours’). However using the following action doesn’t work;
Add 0 months, 5 days, 0 hours, 0 minutes to Variable: vLondonContractHours (Output to Variable: vLondonWeeklyContractHours)
The problem is that this doesn’t work. I’ve also created a number column and set a default value of 5 (for 5 days). Then I created a Calculated Column named ‘Weekly Contract Hours’ with the formula;
 =[Daily Contract Hours]*5,”h:mm”)
The produces an error in the workflow where the calculation is made.
In short I want to multiply one date and time column which is set from an internal variable by another number column which is set to number 5.
Â
Your help will be appreciated.
Thanks, Larry