« Sheet/Cell Protection 101 | Main | Financial Functions : Balloon Loan Example »
November 30, 2005
Converting time to minutes past midnight
To convert a time to the number of minutes past midnight, just multiply by 1440 - as shown below.You also need to make sure the result cell is formatted as a number.
Posted by Dave at November 30, 2005 10:25 PM
Comments
I wonder if this can be a macro/component? Sounds like a simple but nifty thing to have.
Posted by: JZA at December 1, 2005 10:07 AM