Change hrs&minutes into mins
Format Custom as [mm]
If you require a number of minutes to calculate with: =A1*24*60 (time is stored as a fraction of a day)
--
Kind regards,
Niek Otten
"Indie" wrote in message ...
| How do I change Hrs and mins in a cell in one work sheet to autoformat into
| minutes in a cell in another worksheet?
|