Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I Calculate elapsed time worksheet is open
I want to be able to calculate the amount of time that I am working in a
worksheet and display the elapsed in a cell so I can use it in time tracking. Can this be done? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I Calculate elapsed time worksheet is open
When you open a worksheet... type in 1 cell
=Now() Copy that and Paste Special Values in to that cell Then in another cell type =NOW()-"The other cell" Then change the format for that cell to Time, and change it to the 13:00 So everytime you want to update it, press F9. Im sure you can have some worksheet event that does it automatically but I don't know exactly how to do that. "Lloyd" wrote: I want to be able to calculate the amount of time that I am working in a worksheet and display the elapsed in a cell so I can use it in time tracking. Can this be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate Elapsed time: difference between 2 Date/Timestamp perio | Excel Worksheet Functions | |||
Calculate Elapsed Date and Time | Excel Worksheet Functions | |||
calculate elapsed time between dates and times | Excel Worksheet Functions | |||
Ref: Formula to calculate elapsed time between certain dates and t | Excel Discussion (Misc queries) | |||
Formula to calculate elapsed time between certain dates and times | Excel Discussion (Misc queries) |