MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Help me

Posted by Ed Barnes on May 13, 2001 11:58 PM

I have three columns, one is start time of a project, the second is the end, the third is the difference between the two; can someone give me a formula that converts the minutes of the time in the third column, that is the difference, to a percent of an hour; e.g. 12:30 to be converted to 12.50, as the 30 minutes is 50% of the hour.

Posted by Dave Hawley on May 14, 2001 2:32 AM

Hi Ed

Times in Excel are represented as portions of a Day, with 1 being equal to one day (24 hrs). So if you have the Time 12:30:00 in cell A1 you could simply use:


...and format as General or Number.

OzGrid Business Applications

Posted by Ed Barnes on May 18, 2001 12:00 AM

Hello Dave:

Thank you for letting me into the principles of Excel time program - your solution works very well when the time difference is within a 24-hour period, however when it flows into another day, the answer would be wrong, e.g. it give inaccurate result between 20:45pm and 01:45am. Is there something else I'm missing?