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:
=A1*24
...and format as General or Number.
Dave
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?
