View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rajesh Palande Rajesh Palande is offline
external usenet poster
 
Posts: 1
Default convert dd/mm/yy hh:mm AM IST

25/01/10 04:39 AM IST
I want to write a function which will compare the timing given in format
mentioned above with 04:10 pm or 16:10 hrs and highlight if current time is
more that 16:10. Please help me with appropriate formula.