Timeline for How to start countdown for 8 hour in formula field after calculated Now ()-CreatedDate
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 10, 2017 at 11:50 | vote | accept | Md Parwej | ||
| Jul 10, 2017 at 11:23 | comment | added | Md Parwej |
Hi Santanu I need to calculate in negative when time hits 0. So, if priority is p1, I need to start from 0 hour 30 min. As per your above solution, If do it for p1, it start adding 1 hour when minutes is -30. But it should add 1 hour only when minutes is -59 or-60th min. Here is my formula, IF( ISPICKVAL(Priority_Time__c, "P1"), IF(FLOOR( (NOW()- CreatedDate)) > 0,TEXT( FLOOR( (NOW()- CreatedDate)) ) & " days ", "") & TEXT(FLOOR( MOD( (NOW()- CreatedDate)* 24, 24 ) ) ) & " hours " & TEXT( 30 - ROUND( MOD( (NOW()- CreatedDate)* 24 * 60, 60 ), 0 ) ) & " minutes ", "not found")
|
|
| Jul 2, 2017 at 20:48 | history | edited | Santanu Boral | CC BY-SA 3.0 |
edited body
|
| Jul 2, 2017 at 19:26 | vote | accept | Md Parwej | ||
| Jul 10, 2017 at 11:50 | |||||
| Jul 2, 2017 at 19:13 | history | edited | Santanu Boral | CC BY-SA 3.0 |
deleted 62 characters in body
|
| Jul 2, 2017 at 18:54 | history | edited | Santanu Boral | CC BY-SA 3.0 |
added 122 characters in body
|
| Jul 2, 2017 at 18:47 | history | answered | Santanu Boral | CC BY-SA 3.0 |