Date and Time

[firstWeMeet]

I just put this formula
=NOW() then with this format in Cell Format 8/30/2011 3:30 PM
But I would like to revise the format like this Date: 8/30/2011 Time: 3:30 PM
thanks for upcoming help.

 

[VoG]

Try

="Date: "&TEXT(TODAY(),"m/d/yyyy")&" Time: "&TEXT(NOW()-TODAY(),"h:mm am/pm")

 

[firstWeMeet]

Thanks, I have this format now.

 

[VBACO]

with cell that you have entered =Today()
Goto Format>Custom Format and enter
"Date:" m/d/yyyy "Time:" h:mm