View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Daniel.M Daniel.M is offline
external usenet poster
 
Posts: 32
Default Macro on Mac OSX

Hi Michael,

Instead of
If Now Mod 1 12 / 24 Then ' 12/24 = 12:00 PM
use:
If Hour(Now) = 12 Then ' past noon

Regards,

Daniel M.