| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate the difference between two cell entries using NOW() func
I'm having some difficulty displaying the time lapsed between cell entries.
I tried using the now function embedded within an if statement but the now function recalculates everytime I enter something in a new cell giving me an elapsed time of 0. Is there a way to turn the automatic calculation of the now function off without turning automatic calculation off for the entire workbook? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate the difference between two cell entries using NOW() func
No.
You'll need to find a way to temporarily store the initial time value (in a cell or a VBA variable) so you can reuse it afterwards. Anyhow, seems like a VBA job to me. CZeigler schreef: I'm having some difficulty displaying the time lapsed between cell entries. I tried using the now function embedded within an if statement but the now function recalculates everytime I enter something in a new cell giving me an elapsed time of 0. Is there a way to turn the automatic calculation of the now function off without turning automatic calculation off for the entire workbook? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert date | Excel Worksheet Functions | |||
| Cell calculate only once | Excel Worksheet Functions | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| cell entries | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
Linear Mode
