 ShowAll Questionssorted byDate Posted 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 Best Answer chosen by Puja khetan Alain Cabon
Find the Elapsed Time Between Date/Times

```IF(
datetime_1 - datetime_2 > 0 ,
TEXT( FLOOR( datetime_1 - datetime_2 ) ) & " days "
& TEXT( FLOOR( MOD( (datetime_1 - datetime_2 ) * 24, 24 ) ) ) & " hours "
& TEXT( ROUND( MOD( (datetime_1 - datetime_2 ) * 24 * 60, 60 ), 0 ) ) & " minutes",
""
)```

https://help.salesforce.com/articleView?id=formula_examples_dates.htm&type=5 (https://help.salesforce.com/articleView?id=formula_examples_dates.htm&type=5) Alain Cabon
Find the Elapsed Time Between Date/Times

```IF(
datetime_1 - datetime_2 > 0 ,
TEXT( FLOOR( datetime_1 - datetime_2 ) ) & " days "
& TEXT( FLOOR( MOD( (datetime_1 - datetime_2 ) * 24, 24 ) ) ) & " hours "
& TEXT( ROUND( MOD( (datetime_1 - datetime_2 ) * 24 * 60, 60 ), 0 ) ) & " minutes",
""
)```

https://help.salesforce.com/articleView?id=formula_examples_dates.htm&type=5 (https://help.salesforce.com/articleView?id=formula_examples_dates.htm&type=5)

This was selected as the best answer Puja khetan
Thanks Alain ,Great Help .its worked perfectly .