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

Steve,

Apply a custom format of

[m]:ss

to the cell with the time.

HTH,
Bernie
MS Excel MVP


"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

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

Both responses worked great. Thanks for the quick response guys!

"Andy" wrote:

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