Thread: Time conversion
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Seaman Seaman is offline
external usenet poster
 
Posts: 2
Default Time conversion

I want to set a formula in conditional formatting and convert all time
figures (hh:mm) in to normal numbering. Basically I want 12 hrs and 30
minutes to appear 12.50 Is this possible.
--
Peace in the world