Hello I’m seeking support to convert a syntax formula to General Caster but not having any luck. I’ve read all the General Caster documentation and YouTube clips but I must be missing something. Would anyone with a better coding brain be able to assist me?
SUM(LEFT(HOURS_DIFF({Finish},{Start}),2),DIVIDE(RIGHT(HOURS_DIFF({Finish},{Start}),2),60))
I attempted the conversion to General Caster and thought it would be:
(SUM(LEFT(HOUR({Finish}, {Start}), 2), (RIGHT(HOUR({Finish}, {Start}), 2) / 60)))
What this formula is suppose to achieve is the time difference with 2 decimal points. The syntax formula works perfectly in the formula column but there are too many automation restrictions with a formula column so I would prefer to use General Caster.
Any help would be much appreciate.