The expression which you have written will only evaluate to true if values will exactly match with Company name.
According to your requirement you should try this:
CONTAINS(Compoany, "HP") || CONTAINS(Compoany, "H-P") || CONTAINS(Compoany, "NA.Co")
So you're looking to return a single value and stop processing on the first blank field.
To do that, you'd want to chain all of those IF() together instead of completing each one and adding 0 in the "else" case.
First Calculate Minutes between two dates. Then convert hours and minutes . using formula field
Calculate Minutes Formula
( Second_Date__c - Frist_Date__C )*24*60
Convert Minutes in Hours
TEXT(FLOOR( Duration__c / 60))
&' Hours '&
Actually I don't think. You need Workflow rule for this. Hope you can get Customer_Budget__c and Unit Price values via manually. So Please use formula function to achieve this,
For Quantity field formula will be,
Customer Budget / Unit Price
For Total field formula will be,
Quantity * Unit Price
For Remainder Amount field formula will be,
I would solve it with a date field (to record the last changed date), a number formula field (to calculate the number of days since the change), and a workflow rule to set the date. For example, to monitor the opportunity stage field, you might do the following:
Field To Monitor: StageName
Date Field: Stage_Last_Changed_Date__c
Number Formula Field: ...