MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Convert hours & minutes

Posted by Barry Lane on January 24, 2001 8:38 PM

How do I convert hours and minutes in a column to just minutes? Example 1 hour 15 minutes (1:15) to 75 minutes (0:75)

Posted by Dave Hawley on January 24, 2001 9:27 PM

Hi Barry

Go to Format>Cells>Custom and type: [m]


OzGrid Business Applications