If you have something that looks like 0:16:30 and you think it is 0 days, 16
hours and 30 minutes,
it's no, excel thinks it is 16 minutes and 30 seconds,
however just as long as you know that you can convert it, assume the value
is in
A1
=A1*86400
format as general
--
Regards,
Peo Sjoblom
http://nwexcelsolutions.com
"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.