Thread: Changing number to mins/seconds
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Katie Katie is offline
external usenet poster
  
Posts: 130
Default Changing number to mins/seconds
I want to change data that is just a normal number into mins and seconds.
e.g. 80 --- 1:20 or 1.20 or something, so it is recognisable as 1 minute 20
seconds

Katie.
Reply With QuoteReply With Quote