You need to sign in to do that
Don't have an account?
Puja khetan
date time difference formula
experts ,
I have two date time field values
submitted date =date time
released date=date time
total time field is formula return type is number .
for total time i have put like below
released date - submitted date
now result is showing only on days .
i want result should show days ,hours ,minutes
can some one guide if we can do ?
like result is showing 27.56 days
i want it to be 27 days 12 hours and 86 minutes something like this
I have two date time field values
submitted date =date time
released date=date time
total time field is formula return type is number .
for total time i have put like below
released date - submitted date
now result is showing only on days .
i want result should show days ,hours ,minutes
can some one guide if we can do ?
like result is showing 27.56 days
i want it to be 27 days 12 hours and 86 minutes something like this
https://help.salesforce.com/articleView?id=formula_examples_dates.htm&type=5 (https://help.salesforce.com/articleView?id=formula_examples_dates.htm&type=5)
All Answers
https://help.salesforce.com/articleView?id=formula_examples_dates.htm&type=5 (https://help.salesforce.com/articleView?id=formula_examples_dates.htm&type=5)