View original (French)

Monthly hours summed in Excel Android

Fabio -  
PapyLuc51 Posted messages 4569 Registration date   Status Member Last intervention   -

Hello,

I want to add up the hours for the 4 weekly periods in Excel. I saw online that I needed to change the cell format by customizing it and entering  [h]: mm; @

but where do I enter that on Android?

Thank you

Fabien 


5 answers

  2. Fabio
     

    There is only this on this context menu:

    0
  3. PapyLuc51 Posted messages 4569 Registration date   Status Member Last intervention   1 511
     

    Not using it myself on Android, it was a response found after searching online.

    Perhaps by clicking on edit?

    I leave it to the comrades who use it to respond to you or to go to the Microsoft help to find your answer.

    If, worst case, you can't find the answer ad hoc, why not use decimal numbers (for example, 0.25 for 0h15, 0.50 for 0h30...)

    Best regards

    0
  4. Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
     

    Hello.

    It's in Number Format

    You probably need to add the brackets manually ...

    It's nice, retirement! Especially in the Antilles ...
    Raymond (INSA, AFPA)

    0
  6. PapyLuc51 Posted messages 4569 Registration date   Status Member Last intervention   1 511
     

    Hello Fabio and greetings to Raymond

    After watching this video, to access the cell format, you need to click on the small arrow at the bottom right.

    Best regards

    0