Thread
:
converting Days Hours & minutes into just minutes in excel
View Single Post
#
3
Posted to microsoft.public.excel.misc
Niek Otten
Posts: n/a
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.
|
Reply With Quote