Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Automatic System Time (excel)

Comment:

I wish to create a button in a cell of an excel spreadsheet, which places the system time (just time, not date) in cell B3. Any formulas or ideas? Thanks in advanced! Once a hack always a hack

Reply:

Hi Just create a button on the sheet and use this macro. This shows the time as 13:24. Private Sub CommandButton1_Click() Range("A1").Value = Mid$(Now(), 12, 5) End Sub

0

Reply:

Use =Now() which will disply the time and date. Then format the cell as Time which will only display the time. The time will be updated every time the worksheet is recalcualted or by pressing F9. Stuart

0

Merge rows in Excel &...

question about using Word

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Hi friends I am designing Cafe Project in Excel. There are two coloumns "Customer Name" & "Order Time". My requirement is that when I enter the Customer Name, in the next column Current System Time sh...

Summary: Hello, I have a user running office XP pro using Outlook ONLY for the calendar, not for email. She uses Netscape for email. She's confirmed the calendar time zone settings to MST (same as system tim...

Summary: i kinda rushed what i said so i thought i would explain it a bit better. i have made up a pay system is excel that automatically calculates super and tax and bonuses etc for a made up business. there ...