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.