Time Entry

[Hakan Dagtas]

I have some time figures such as 1 hrs 30 minutes. I would
like to key in this as 01:30 in to a cell and it will
appears in minute format as in 90 minutes. Is this
possible ?

 

[Chip Pearson]

Hakan,

Use a custom number format of [mm]. The square brackets prevent Excel from
"rolling over" the minutes at 60 minutes.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com