View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default converting Days Hours & minutes into just minutes in excel

Format Custom as [mm]
If you want to calculate with it as number 990:

=A1*24*60

--
Kind regards,

Niek Otten

"Six Sigma Blackbelt" <Six Sigma wrote in message
...
| converting Days Hours & minutes into just minutes in excel, this is my data
| set - 0:16:30 in Day hours and minutes, I need to change this to just minutes
| wich would be 990 minutes, how can i do this please.
|