="There are "&ABS(ROUNDDOWN("12/24/2004 23:59:59"-NOW(),0))&" days
"&ABS(HOUR(NOW())-HOUR("12/24/2004 23:59:59"))&" hours
"&ABS(MINUTE(NOW())-MINUTE("12/24/2004 23:59:59"))&" minutes, an
"&ABS(SECOND(NOW())-SECOND("12/24/2004 23:59:59"))&" seconds left unti
Christmas!"
results:
There are 135 days, 9 hours, 22 minutes, and 51 seconds left unti
Christmas!
When it is 8/11/2004 14:37:08.
Is that what you mean
