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 |
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 |
All times are GMT +1. The time now is 10:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com