Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Will Excel's time function do this?
(Sorry if this is a cross post)
Excel 2003 I need a cell to display the "time until" an event. I set it up using to cells, a simple "=now()" function in one and the date/time of the event in the other & a 3rd cell with the event cell minus the now cell (formatted h:mm:ss). Two questions please. First & most important, this works okay for the event (same day as now) but I have to keep hitting F9 to recalc for it to be accurate. Is there a way to have de destination cell "running" constantly so you can see the seconds ticking down continuously? Also (unrelated to the 1st question) instead of showing hours/minutes/seconds until the event in one cell, can I break it up into several? I.e.; days, hour, minutes, seconds until event in separate cells? (or another way if the event is several days from now). Thanks in advance... Bob |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Will Excel's time function do this?
Bob, you could try this A2 =NOW() B2 = future date e.g. 25-Dec-2006 C2 =INT(B2-A2) D2 =INT((B2-A2-C2)*24) E2 =MOD(INT((B2-A2)*1440),60) F2 =MOD(INT((B2-A2)*86400),60) C2:F2 gives you days hours minutes and seconds between your now and your date to update automatically you need VBA - see Joe Was contribution here http://www.mrexcel.com/board2/viewtopic.php?t=98916 -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=506642 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I freeze the time in the NOW() function? | Excel Worksheet Functions | |||
conditional formatting with time values | Excel Discussion (Misc queries) | |||
Time Function | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions | |||
What function do I use to convert "time" to minutes? | Excel Worksheet Functions |