Formula value

ich möchte 2 spalte stunde minus machen in monday und ergebnius in zahlen splate spiechern , wie kann ich?

Which product (CRM/Work Management, etc) and level (Pro/Enterprise) do you have?

Hallo workmnagmwnt und enterprise

Hi @zohreh, welcome to the community! :waving_hand:

You can do this using a Formula column. If your Hour columns are named Hour 1 and Hour 2, use:

{Hour 1} - {Hour 2}

This will subtract Hour 1 from Hour 2 and return the result in the formula column.

And if you’d like to display Hr / Hrs after the value, you can use:

IF({Hour 1} - {Hour 2} < 10, CONCATENATE({Hour 1} - {Hour 2}, " Hr"), CONCATENATE({Hour 1} - {Hour 2}, " Hrs"))

Hope this helps!!

ich möchte dise rule

Hi @zohreh ,

Since you have the Enterprise plan, I suggest using workflows (Workflow Builder). Also, download the app Workflow Blocks: Formula by SpicyTab. It’s Free to use. Follow the steps below and it should work like a charm.

Your Trigger will be “When Art Personal changes”.