Time Entry

  • Thread starter Thread starter Hakan Dagtas
  • Start date Start date
H

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 ?
 
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
 
Back
Top