Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countdowns
I am trying to do a countdown to show the number of days, hours and minutes from now until a specific date. I can do this for the number of days but am struggling with the hours and seconds so if someone could help, it would be greatly appreciated. Thank you -- Angel160 ------------------------------------------------------------------------ Angel160's Profile: http://www.excelforum.com/member.php...o&userid=15503 View this thread: http://www.excelforum.com/showthread...hreadid=489032 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countdowns
Hi
=A1-NOW() formatted as "d hh:mm" where A1 contains the date(time). But you have to refresh the formula manually (press F9). There exists no built-in Timer event in Excel. -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) "Angel160" wrote in message ... I am trying to do a countdown to show the number of days, hours and minutes from now until a specific date. I can do this for the number of days but am struggling with the hours and seconds so if someone could help, it would be greatly appreciated. Thank you -- Angel160 ------------------------------------------------------------------------ Angel160's Profile: http://www.excelforum.com/member.php...o&userid=15503 View this thread: http://www.excelforum.com/showthread...hreadid=489032 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|