OpenOffice Calc Tips

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.

This entry was posted on Wednesday, November 30th, 2005 at 9:19 pm and is filed under Date & Time. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.