I'm getting Expected value or varible when I put in this code. Do i need to
add something else? sorry for being so green at this.

"Jim Thomlinson" wrote:

MsgBox Time()
or
Sheet1.Range("A1").Value = Time()
--
HTH...

Jim Thomlinson


"sherobot" wrote:

Can someone tell me how to code a macro to display the current time is a
cell. I am able to get the date and time with using the Now coding, but can't
seem to get the only the hours and the minutes. I know this is an easy
fix...but help I'm a newbie