| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
