0
votes
1answer
29 views

Excel reformatted numbers to times

I have a spreadsheet stored on a company sharepoint site. Only one person in my team will use it at any time, when they're finished it saves and is available to another user. Periodically when someone ...
0
votes
2answers
129 views

Excel function for calculating total spent time

I have an excel sheet, where in some columns I have cells of the type "integer,integerM" or "integer,integerH", for instance "1,30m" or "5,2H". For all the column I would like to get an expression ...
1
vote
1answer
2k views

Convert from seconds to minutes in Open Office

I have several cells with a time value in seconds e.g (23, 102, 543, ...) I am not very familiar with the formula functions in Open Office. How do I address the same Cell-Box with the value in it? I ...