Thanks that was a life saver, thanks again.

"Niek Otten" wrote:

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.
|