ExcelBanter - how to include real time & date on a worksheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how to include real time & date on a worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/18912-how-include-real-time-date-worksheet.html)

nde

how to include real time & date on a worksheet

how to include real time & date on excel spread sheet

Barb R.

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

All times are GMT +1. The time now is 07:01 PM.