Hours to minutes

S

Steve

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
 
B

Bernie Deitrick

Steve,

Apply a custom format of

[m]:ss

to the cell with the time.

HTH,
Bernie
MS Excel MVP
 
S

Steve

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

Andy said:
Hi

Format the cell as [mm]

Andy.

Steve said:
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
Click to expand...
Click to expand...
 
Top