Displaying date/time!

Preet,

'Now' returns both the date and time, so you can use the Format
function to return a date/time string in any format you want.
E.g.,

Range("A1").Value = Format(Now, "mm/dd/yyyy hh:mm")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Preet" <Preet.1tg86m_1123509982.4596@excelforum-nospam.com>
wrote in message
news:Preet.1tg86m_1123509982.4596@excelforum-nospam.com...
>
> THANK YOU David!
>
> That worked - BUT! How do I get time displayed? (excluding
> seconds)
>
> THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU
> THANK YOU
> THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU
>
>
> --
> Preet
> ------------------------------------------------------------------------
> Preet's Profile:
> http://www.excelforum.com/member.php...fo&userid=3155
> View this thread:
> http://www.excelforum.com/showthread...hreadid=393818
>

Hi Chris

Thank you for ur reply, that worked!

Very Grateful.

Preet x