View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spiky Spiky is offline
external usenet poster
 
Posts: 622
Default Converting time :: Excell 2007

Oops, I left an extra mess in that post. Ignore that second formula.
This is the one that should work:
=VALUE(LEFT(A1,SEARCH(":",A1,1)-1))+(VALUE(MID(A1,SEARCH
(":",A1,1)+1,2)/60))