Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Display Question Please
I have the simplest of formulas to give me the time until an event takes
place. In one cell I have the now function ( =now() ). In another cell the date/time of the event. In a third cell the event date/time-now formula (formatted h:mm:ss). It works fine but I have to hit F9 to recalculate. Can I get it to display a constantly updating time showing the seconds ticking away? Also how can I get it to show the months and days away an event is in addition to hours/min/sec? Thanks... Bob |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Display Question Please
http://www.mvps.org/dmcritchie/excel...ime.htm#clocks
look for real time clock -- Regards, Peo Sjoblom Portland, Oregon "Bob Newman" wrote in message news:2qeEf.1848$c64.535@dukeread12... I have the simplest of formulas to give me the time until an event takes place. In one cell I have the now function ( =now() ). In another cell the date/time of the event. In a third cell the event date/time-now formula (formatted h:mm:ss). It works fine but I have to hit F9 to recalculate. Can I get it to display a constantly updating time showing the seconds ticking away? Also how can I get it to show the months and days away an event is in addition to hours/min/sec? Thanks... Bob |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Display Question Please
I must not have made myself clear. I am not looking for a clock. I want a
cell in an Excel 2003 spreadsheet to display the time (counting down) until an event (date & time) in another cell of that spreadsheet. Bob "Peo Sjoblom" wrote in message ... http://www.mvps.org/dmcritchie/excel...ime.htm#clocks look for real time clock -- Regards, Peo Sjoblom Portland, Oregon "Bob Newman" wrote in message news:2qeEf.1848$c64.535@dukeread12... I have the simplest of formulas to give me the time until an event takes place. In one cell I have the now function ( =now() ). In another cell the date/time of the event. In a third cell the event date/time-now formula (formatted h:mm:ss). It works fine but I have to hit F9 to recalculate. Can I get it to display a constantly updating time showing the seconds ticking away? Also how can I get it to show the months and days away an event is in addition to hours/min/sec? Thanks... Bob |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Display Question Please
I have a workbook that shows a countdown timer. Mail me direct if you want a
copy bob (dot) phillips (at) tiscali (dot) co (dot) uk do the obvious with the bits in brackets -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Bob Newman" wrote in message news:6JeEf.1852$c64.351@dukeread12... I must not have made myself clear. I am not looking for a clock. I want a cell in an Excel 2003 spreadsheet to display the time (counting down) until an event (date & time) in another cell of that spreadsheet. Bob "Peo Sjoblom" wrote in message ... http://www.mvps.org/dmcritchie/excel...ime.htm#clocks look for real time clock -- Regards, Peo Sjoblom Portland, Oregon "Bob Newman" wrote in message news:2qeEf.1848$c64.535@dukeread12... I have the simplest of formulas to give me the time until an event takes place. In one cell I have the now function ( =now() ). In another cell the date/time of the event. In a third cell the event date/time-now formula (formatted h:mm:ss). It works fine but I have to hit F9 to recalculate. Can I get it to display a constantly updating time showing the seconds ticking away? Also how can I get it to show the months and days away an event is in addition to hours/min/sec? Thanks... Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display a number as Kilometers and k/hr & as Time | Excel Discussion (Misc queries) | |||
Entering Times | Excel Discussion (Misc queries) | |||
Time question | Excel Discussion (Misc queries) | |||
Time Sheets | New Users to Excel | |||
unmet challenge | Excel Worksheet Functions |