Using Open Office date/time values for calculations with regular numbers

I had a a date/time field in a time sheet which contained the sum of other date/time fields in the form hh:mm. I want to use it as a regular number to convert them in a very client specific format. The solution is very simple:

24:00 will be converted to 1.0

I hope that’s a general rule, not specific to my current Open Office version.

Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s