Subtraction of Two Time Fields No Longer Produces Negative Results in Salesforce

Previously, subtraction of two time datatype fields in Salesforce could result in a negative value.

Starting in the Summer '18 release, subtraction is always a positive value on a 24-hour clock.

Example:

---

When calculating the number of hours a business is open, you use the following formula (also taking into account each hour is 3,600,000 milliseconds):

(ClosedTime - OpenTime) / 3600000

ClosedTime = 5 PM, OpenTime = 8 AM, 
then result is ClosedTime - OpenTime = 9 hours

ClosedTime = 5 AM, OpenTime = 7 AM, 
then result is ClosedTime - OpenTime = 22 hours

ClosedTime = 5 AM, OpenTime = 11 PM, 
then result is ClosedTime - OpenTime = 6 hours

Latest Salesforce Interview Questions and Answers:

Salesforce Interview Questions - Part 1

Salesforce Interview Questions - Part 2

Salesforce Interview Questions - Part 3

Salesforce Interview Questions - Part 4

Salesforce Interview Questions - Part 5

Salesforce Interview Questions - Part 6

Salesforce Interview Questions - Part 7

Salesforce Interview Questions - Part 8

More Salesforce Blogs:

Check out Salesforce Daily Limit Only in 5 Simplest Steps
Learning Pagination In Salesforce Is Not Difficult At All ! You Just Need 3 Easy Steps
How To Learn Get Field Values From Visualforce Page To Apex Class Controller Without Losing Your Mind
Main Difference Between ISBLANK And ISNULL in Salesforce
How To Get Total Amount Of Records Processed In Batch Job In 10 Minutes And Still Look Your Best 
Export VisualForce Data into Excel Sheet in 3 Easiest Steps
7 Easy Steps to Generate Apex Class From WSDL In Salesforce
Simplest Way To Find Number of Days Between Two Dates in Salesforce
3 Easy Steps To Send Emails With Attachment From Your Apex Class In Salesforce
How Insert Comma In Formula Fields Can Help You Improve Your Productivity
Simple Guidance For You In Access Of Subquery Field Value Using Apex - Upwards Traversal.
Access Subquery Field Value Using Apex in 2 Easy Steps- Downwards Traversal

How Learning Enable Inline Editing In Visual Force Pages Could Save Your Money And Time

Enjoy! If you have any questions, comments etc. please feel free to let me know. As always, please feel free to get in touch me as I would be more than happy to assist you with any of your Salesforce development needs.