How to show current date and time

[vsr_kmb]

Hello,
I want to show current date and current time in a single cell. I have
tried by using today() and now() functions separately, i dont know how
to use together in a sigle cell. I want like 28-Mar-06, 12.05 PM. Also
I want to add text to it. Like Report for 28-Mar-06.
Experts please help me
Thanks
Ravi

 

[Pete_UK]

Try this:

="Report for "&TEXT(NOW(),"dd-mmm-yy, h.mm AM/PM")

You need to use NOW() if you need the time as well as the date.

Hope this helps.

 

[Gary''s Student]

Enter =NOW() in a cell and format as dd-mmm-yy hh:mm

to get text as well format as "Report for "dd-mmm-yy hh:mm

You don't even need to concatenate anything

 

[CLR]

Hi Ravi........
Here's a little macro that will do it for you.......

Sub TimeStamp()
' Select a cell and run this macro to Date/Time stamp
ActiveCell.FormulaR1C1 = "Report for " & Date & " " & Time
End Sub

hth
Vaya con Dios,
Chuck, CABGx3

 

[CLR]

Hi Ravi...........
Here's a formula solution..........

="Report for "&TEXT(NOW(),"MMM dd, yyyy hh:mm AM/PM")

hth
Vaya con Dios,
Chuck, CABGx3