Thread: Determining AM or PM in text string
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bob is offline
external usenet poster
  
Posts: 972
Default Determining AM or PM in text string
Carim - Thanks!
Bob

"Carim" wrote:

Hi Bob,

="As of "&MONTH(NOW())&"/"&DAY(NOW())&" @
"&HOUR(NOW())&":"&MINUTE(NOW())&" "&IF(HOUR(NOW())12,"PM","AM")

HTH
Carim


Reply With QuoteReply With Quote