# Calc and Hour duration format?

I am so confused by the format Calc is expecting. I am former Numbers user(Apples version of Calc) what am trying to achieve is to regard a cell that has a single digit as an hour and append "H" to the end. For example, 3 will be reformatted to 3 H Right now I am getting some weird calculations. I've tried applying HH" H" to cell that has a single digit, it turns the cell into 00 H

```
HH" H" 22:33:22 22 H
HH" H" 221122 00 H
HH" H" 222 00 H
HH" H" 2 00 H
```

It keeps inserting 000s into the cell, the only one that gives me some result is the first one. but having to type

22:33:22

for every cell is not ideal. Instead how can I get calc to just regard any digit as an hour?

Thank you

You don't want parts of an hour? Try format

`[HH] "H"`

I don't know how Numbers handled data with the letter H, but you probably already guessed that Calc is a slightly different program, right? Everything would be much easier if there were 100 seconds in a minute, 100 minutes in an hour, and 100 hours in a day. While this is not the case, leave the values as you enter, and for further calculations use the

TIME(your_value;0;0)function or divide your number by 24.The question is what you are trying to do with the cell. If your idea is to put any number there, and have it

displayedas "<this_number> H", then it's as easy as using`0" H"`

format string (but note that it wouldroundany fraction, not truncate, so putting2.6into the cell, you will have`3 H`

). But then you have not a time in your cell, just a number formatted with a suffix. If you want to use the cell further in time calculations, you would either need to account for this, and divide the rounded value by 24; or you would need to do the correct thing from the start, and puttimeinto the cell, i.e. writing e.g.`2:00`

, not`2`

.The zeroes that you correctly get when format a cell containing a whole number as time are because times ...(more)

Also posted at https://stackoverflow.com/questions/6....

Also posted at https://old.reddit.com/r/libreoffice/comments/lvtb56/calc_and_hour_duration_format/