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]


Dave

OzGrid Business Applications