View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Get System Date & Time[_2_] Get System Date & Time[_2_] is offline
external usenet poster
 
Posts: 4
Default How can I get the system date & time for different cell record



"Bob Phillips" wrote:

Be aware though that it only shows hours and minutes, not the seconds.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Get System Date & Time" wrote
in message ...

Thanks Bob. You are right. hh:mm is fine with me. By the way, Dave, I use a custom format in the cell and was able to display the date in the right format.