Return to Question

added 16 characters in body

Source Link

edited Jul 2, 2017 at 18:18

36.2k
8
45
72

I am getting result after one minute in formula field like this 0 Days 0 Hours -479 Minutes. I need result like this 0 Days 7 Hours -59 Minutes.

This is my formula but it's not working properly

TEXT( FLOOR(Now() - CreatedDate)) & " Days " &TEXT( ROUND(MOD((Now() - CreatedDate)*24,24),0) ) &" Hours " & TEXT(ROUND(MOD((Now() - CreatedDate)*1440,60),0)-480 ) &" Minutes "

TEXT( FLOOR(Now() - CreatedDate))  & " Days " &TEXT(
ROUND(MOD((Now() - CreatedDate)*24,24),0) )  &" Hours " &
TEXT(ROUND(MOD((Now() - CreatedDate)*1440,60),0)-480
) &" Minutes "

Please if you have any solution thanks in advance.

I am getting result after one minute in formula field like this 0 Days 0 Hours -479 Minutes. I need result like this 0 Days 7 Hours -59 Minutes.

This is my formula but it's not working properly

TEXT( FLOOR(Now() - CreatedDate)) & " Days " &TEXT( ROUND(MOD((Now() - CreatedDate)*24,24),0) ) &" Hours " & TEXT(ROUND(MOD((Now() - CreatedDate)*1440,60),0)-480 ) &" Minutes "

Please if you have any solution thanks in advance.

I am getting result after one minute in formula field like this 0 Days 0 Hours -479 Minutes. I need result like this 0 Days 7 Hours -59 Minutes.

This is my formula but it's not working properly

TEXT( FLOOR(Now() - CreatedDate))  & " Days " &TEXT(
ROUND(MOD((Now() - CreatedDate)*24,24),0) )  &" Hours " &
TEXT(ROUND(MOD((Now() - CreatedDate)*1440,60),0)-480
) &" Minutes "

Please if you have any solution thanks in advance.

Source Link

asked Jul 2, 2017 at 18:01

Md Parwej

How to start countdown for 8 hour in formula field after calculated Now ()-CreatedDate

I am getting result after one minute in formula field like this 0 Days 0 Hours -479 Minutes. I need result like this 0 Days 7 Hours -59 Minutes.

This is my formula but it's not working properly

TEXT( FLOOR(Now() - CreatedDate)) & " Days " &TEXT( ROUND(MOD((Now() - CreatedDate)*24,24),0) ) &" Hours " & TEXT(ROUND(MOD((Now() - CreatedDate)*1440,60),0)-480 ) &" Minutes "

Please if you have any solution thanks in advance.

formula formula-field