Question about Microsoft Windows XP Professional
Need to update column "I" with current time as each employee checks into our excel check in sheet by entering 'here' in column "B". The time updates for every employee as each employee checks in rather then the column there name is in.
No formula needed. Highlight the cells that you want to put the time into. These are Raw data cells. You can use other cells to calculate their times. Right click and Format Cells, choose time and the appropriate format you would like.
To insert the time click in the cell you want and do a CTRL-SHIFT-;
That is Control - Shift - Semi-Colon. This will insert the Time. Leave out the Shift and you will insert the date.
Dim vTime as Variant
vTime = Format)Now, "hh:mm:ss am/pm")
ActiveCell.Value = vTime
Now add the forms toolbar to your excel.
Click Button to add a button.
Choose the GetTime() Macro
Rename and resize your button.
Click in the field you want to time to go to.
Click the Time button.
Posted on Jun 10, 2008
Read the fine manuals.
Posted on Jun 10, 2008
Tips for a great answer:
Feb 22, 2011 | Operating Systems
The default Excel
file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets
(.xlm files in Excel 4.0).
Uses the same basic
XML format as the Excel Workbook, but can store VBA macro code. Users saving
an Excel workbook that has VBA code or Excel 4.0 macro sheets (.xlm files in
Excel 4.0) are prompted to use this file format.
The default file
format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro
sheets (.xlm files in Excel 4.0).
Can contain a
VBAProject part or Excel 4.0 macro sheets (.xlm files in Excel 4.0).
Workbooks created from this template inherit the VBAProject part or Excel 4.0
macro sheets that exist in the template.
program that runs additional code. Excel add-ins use the Open XML file format
to store data, and they support using VBA projects and Excel 4.0 macro
Feb 21, 2011 | Operating Systems
Nov 15, 2010 | Microsoft Windows XP Professional
Apr 01, 2010 | Microsoft Windows XP Professional
Mar 17, 2010 | Operating Systems
Nov 23, 2009 | Microsoft Windows XP Home Edition
Sep 23, 2009 | Operating Systems
May 24, 2008 | Microsoft Windows XP Professional
Jan 30, 2008 | Microsoft Windows XP Home Edition
101 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: