Copy link to clipboard
Copied
Hi Guys,
How to display countdown? I have list of items that would have counddown when will it be completed.. see examples below...
ITEM END TIME
A 2 days, 3 hours, 15 mins, 4 secs
B 3 days, 1 hour, 35 mins, 0 sec
C 1 day, 2 hours, 10 mins, 54 secs
D COMPLETED
E 4 days, 10 hours, 1 min, 32 secs
F COMPLETED
I already did it but I got problem... Only item A has the countdown, the rest is NULL...
Please help me get over this. Thanks. Need your urgent help.
Best Regards,
Bill
Copy link to clipboard
Copied
How did you get A to count down? What are you doing to try to get the other one's to count down?
Copy link to clipboard
Copied
Sorry I forgot to tell the formula
END TIME = end date - today
Example:
End time = "4/12/2012 12:00 PM" - "4/11/2012 3:00 AM"