how to include real time & date on a worksheet

how to include real time & date on excel spread sheet

I was supplied with a small macro that would enter the current date/time in a
cell when invoked.

Sub NOWTIME()
ActiveCell.Value = Format(Now(), "mm-dd-yyyy h:mm:ss AM/PM")
End Sub

Is that what you want?

Barb Reinhardt

"nde" wrote:

> how to include real time & date on excel spread sheet