Six Sigma Blackbelt Wrote:
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.

If you're just concerned with what is displayed.....

If you input 0:16:30 in excel then this will be interpreted as 16
minutes 30 seconds.In this case to display as 990 custom format as [s]

If you do indeed have a cell formatted as d:hh:mm which shows 0:16:30
then just reformat as [m] and it should show 990


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=537357