Thread: Convert text entered as minutes/seconds to minutes
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kathie kathie is offline
external usenet poster
  
Posts: 10
Default Convert text entered as minutes/seconds to minutes
I have several entries (formatted as text) for example, :31, 1:04, 4:53,
23:34. These numbers indicate minutes and seconds (31 seconds, 1 hour 4
seconds, etc).
What formula can I use to convert these entries into seconds?
Reply With QuoteReply With Quote