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

Hi

Format the cell as [mm]

Andy.

"Steve" wrote in message
...
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