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