Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Excel: Automatic time update in cel
Name: Bignelis Date: February 1, 2008 at 10:23:26 Pacific OS: Windows XP CPU/Ram: Centrino Duo 2GB Ram Product: HP
Comment:
Hi,
I would like to create an automatic time-tracker. In order to do so I need to have the actual time in a cell. When I use the NOW() function this only updates when I press F9. Is there any way to automate this?
Name: DerbyDad03 Date: February 1, 2008 at 11:54:58 Pacific
Reply:
Paste this code into a regular module and run the StartTimer code.
Public RunWhen As Double ' Set interval to 1 second Public Const cRunIntervalSeconds = 1 ' Define name of procedure to run Public Const cRunWhat = "The_Timer"
Sub StartTimer() RunWhen = Now + TimeSerial(0, 0, cRunIntervalSeconds) Application.OnTime _ EarliestTime:=RunWhen, _ Procedure:=cRunWhat, _ Schedule:=True End Sub
Sub The_Timer() With [A1] .Formula = "=now()" .NumberFormat = "hh:mm:ss;@" End With StartTimer End Sub
Summary: I hate time calculations in Excel. Here's what I tried. A1: 8:11 AM B1: 4:58 PM C1: =(B1-A1)*24-.5 Result: 8.28 Repeat that for 3 more working days. In C5 I put: =40-SUM(C1:C4)+0.5 Result: 7.37 Does ...
Summary: Excel 2002 doesnt open in XP, but works fine in windows2000.I get the following error "errors were detected in "filename.xls" , but microsoft excel was able to open the file making the repairs listed ...
Summary: Normal calculating time differences is simple a matter of subtracting one from the other, that is providing the fields are defined as Time/Date fields. Time/Date are stored as floating point numbers....
0 
