Planification
Kiki0302
Posted messages
1
Status
Membre
-
via55 Posted messages 14730 Registration date Status Membre Last intervention -
via55 Posted messages 14730 Registration date Status Membre Last intervention -
Hello,
I would like to integrate combined formulas into the schedule that my manager absolutely does not want to modify.
I must be missing a step somewhere because I'm not getting anywhere.
I've attached an excerpt of this famous schedule for clarification.
Thank you in advance for your help, and I'm available if you need more information about what I want to do.
See you soon!!
Configuration: Windows / Internet Explorer 11.0
I would like to integrate combined formulas into the schedule that my manager absolutely does not want to modify.
I must be missing a step somewhere because I'm not getting anywhere.
I've attached an excerpt of this famous schedule for clarification.
Thank you in advance for your help, and I'm available if you need more information about what I want to do.
See you soon!!
Configuration: Windows / Internet Explorer 11.0
2 réponses
Hello
How do you expect us to help you with just a simple image!!!
Post an example of your file on cjoint.com, create a link that you copy and come back to paste it here while explaining in detail what formulas you want to insert and for what purpose
Best regards
Via
--
"Imagination is more important than knowledge." A. Einstein
How do you expect us to help you with just a simple image!!!
Post an example of your file on cjoint.com, create a link that you copy and come back to paste it here while explaining in detail what formulas you want to insert and for what purpose
Best regards
Via
--
"Imagination is more important than knowledge." A. Einstein
1) To share your file, try mon-partage.fr, just select the file and start the sharing
2) To count the m, use COUNTIF
3) If all sheets are identical in their layout, you just need to have one template sheet with the formulas and then copy that template
Best regards
Via
--
"Imagination is more important than knowledge." A. Einstein
2) To count the m, use COUNTIF
3) If all sheets are identical in their layout, you just need to have one template sheet with the formulas and then copy that template
Best regards
Via
--
"Imagination is more important than knowledge." A. Einstein
I managed to insert the formula to apply colors based on shifts (morning, evening, presence, etc.)
I'm going to simplify my request because I don't think it's necessarily useful... Actually, I would like to set it up so that if the cell contains m, s, p, the number of hours below should be reflected. So, for example, 7.80... so that at the end of the week I can insert the sum formula to calculate the total number of hours per employee.
I would also like to know how to copy the layout of these formulas to other sheets in the workbook to plan ahead each month and avoid having to redo all the formula entries manually...
Thank you in advance.