View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default 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?