From your description I think you are trying to add a fifth column that is “total time excluding lunch break”?
Make sure the “Lunch break (total time in minutes)” field is of type “Number”. Then in this new column you can simply use the formula:
{Temps pour feuille} - {Période temps de repas}
From your description I think you are trying to add a fifth column that is “total time excluding lunch break”?
Make sure the “Lunch break (total time in minutes)” field is of type “Number”. Then in this new column you can simply use the formula:
{Temps pour feuille} - {Période temps de repas}
Hi Nathaniel!
In fact, I was trying not to add a new field to keep the base as simple as possible, but it does make sense to add a new field and just hide the one that adds up the total time of the day. Thanks for the advice!
Hi Nathaniel!
In fact, I was trying not to add a new field to keep the base as simple as possible, but it does make sense to add a new field and just hide the one that adds up the total time of the day. Thanks for the advice!
Ah!
You can do it either way. This formula will do all the work in one step:
DATETIME_DIFF({Fin affectation},{Début affectation},‘minutes’) - {Période temps de repas}
Do make sure that the “Période temps de repas” is of type Number
Ah!
You can do it either way. This formula will do all the work in one step:
DATETIME_DIFF({Fin affectation},{Début affectation},‘minutes’) - {Période temps de repas}
Do make sure that the “Période temps de repas” is of type Number
Great!
It is exactly what I was looking for, but I was putting Période temps de repas at the wrong place (before ‘minutes’). So everything is working just fine. Thank you very much!
