Monthly hours summed in Excel Android

Fabio -  
PapyLuc51 Posted messages 4567 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

PapyLuc51 Posted messages 4567 Registration date   Status Member Last intervention   1 511
 

Hello,

The command to change the cell format may be in the context menu. See the touch guide below (10th item)

https://support.microsoft.com/fr-fr/office/guide-tactile-d-excel-pour-android-aef977da-6adf-4724-b054-8ca4bb1d7afb

Sincerely

0
Fabio
 

There is only this on this context menu:

0
PapyLuc51 Posted messages 4567 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
Raymond PENTIER Posted messages 58207 Registration date   Status Contributor Last intervention   17 476
 

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
PapyLuc51 Posted messages 4567 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