View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve
 
Posts: n/a
Default Hours to minutes

The cell is displaying 1:00. The actaul data entered is 1:00:00 AM. I would
like it to be displayed in minutes. For example, instead of 1:00, it would
show either 60 or :60 or even :60:00 would do.

Thanks for any help you are able to offer.

Steve