Thread: convert 00:06 minutes to 6
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ditchy Ditchy is offline
external usenet poster
  
Posts: 7
Default convert 00:06 minutes to 6
Hello
how can I convert 00:06 minutes to 6
tried the =RIGHT(AA8,LEN(AA8)-4)*1
but can't seem to get it to work?
could some one please point me in the right direction.
regards
Ditchy
Reply With QuoteReply With Quote