Thread: How to i display 15 as 15 mins without showing the date (EXCEL)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jonathan Jonathan is offline
external usenet poster
  
Posts: 138
Default How to i display 15 as 15 mins without showing the date (EXCEL)
I want to type 15 into the box so that it displays as 00: (15 mins) I thought
I had found a way but it insits on including the date which is irrelevant or
turning the figure into days
Reply With QuoteReply With Quote