| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time in Excel
I am trying to do something that seems impossible. I am a paramedic and use
a mobile device during the course of my job. I am trying to write a spreadsheet that will "time stamp" important times within a run. I have been using: =IF(A3=1,NOW(),"") I enter a 1 in Column A and the equation is in Column C, but it resets all time to the same since NOW() is a volatile function. Is there anyway to overcome this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Standard Time to Military Time in Excel | Excel Discussion (Misc queries) | |||
| Time difference calculations, daylight savings time, Excel | Excel Discussion (Misc queries) | |||
| In Excel, I want to convert Eastern time to pacific time | Excel Discussion (Misc queries) | |||
| Negative time should be allowed in Excel, eg time difference | Excel Discussion (Misc queries) | |||
| Accumulate weekly time to total time in Excel. | Excel Discussion (Misc queries) | |||
Threaded Mode
