Question

1

How to convert floating point value into decimal value in open office?

rated 0 times [ 1] [ 0] / answers: 1 / hits: 1495 / 1 Year ago, tue, march 7, 2023, 10:37:54

In spreadsheet i have more than 5 columns, every columns showing its own value. One of the column shows the talk time as follows,

I just want to round up this values, as follows.

For example 01:25 If the talktime is equal to & above 25seconds it should be rounded as 02 but if the talktime is 01:13 then it should round it as 01 and not as 02.

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

inciplyies

Add To Favorites

Follow

Total Points: 10

Total Questions: 114

Total Answers: 93

Location: French Polynesia

Member since Sun, Dec 20, 2020

3 Years ago

answered 1 Year ago utilitere · Accepted Answer

I tried to fiddle with Format -> Cell with no sucess. The problem is OpenOffice treats XX:YY values as hours and minutes, NOT minutes and seconds. But you could try this:

Input your times with HH:MM:SS format. Like 00:08:48. Say that is A1 cell.

Add an aditional column, and input thiis formula in (say B1):
```
=minute(A1)+if(second(A1)>=25,1,0)
```

Or, if you dont like adding "00:" to all values, and dont mind OO interpreting it as HH:MM, use this formula instead:
```
=hour(A1)+if(minute(A1)>=25,1,0)
```

If you dont like using 2 columns for 1 value (1 for "raw", real value and the other for the formmated value), just right-click the undesirable column and select Hide