Advertisement
Guest User

Excel Countdown Timer

a guest
Oct 31st, 2014
130
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.59 KB | None | 0 0
  1. =IF((A1 - GoogleClock()) <= 0, "Event is over", INT(A1 - GoogleClock()) & " Day" & IF(INT(A1 - GoogleClock()) = 1, " , ", "s, ") & INT(MOD(A1 - GoogleClock(), 1)*24) & " Hour" & IF(MOD(A1 - GoogleClock(), 1) < 1/24, "s, and ", IF(MOD(A1 - GoogleClock(), 1) <= 1/12, ", and ", "s, and ")) & INT(MOD(A1 - GoogleClock(), 1/24)*1440) & " Minute" & IF(MOD(A1 - GoogleClock(), 1/24) < 1/1440, "s, and ", IF(MOD(A1 - GoogleClock(), 1/24) <= 1/720, "", "s")))
  2.  
  3. *there's a bug at 0 Days, 0 Hours, and 0 Minutes that makes it display "0 Days, 0 Hours, and 0 Minutes, and", but the "Event is over" line hides it
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement