Rafa_Ramos - profile

Rafa_Ramos · Sep 06, 2021

Hi! I am trying to sum certain values from a specific row and column and I don’t know how to do it. Better to explain it with an example: In this image I am trying to get the following value in the third column: (1 + 2 + 3 + 4) / 4 = 2.5. That is, ...

Rafa_Ramos · May 26, 2021

Hello everyone! I’ve got several cols (days of the week) that have a time that I wasted in doing a task in minutes (ex: 120). All that I’m trying to do is a SUM of this minutes but in a h:mm format. Example: The task is “Book Design” and the minutes ...

Rafa_Ramos · Sep 06, 2021

Hi Justin! Thanks for your reply. The answer of your question is that “the number of the first column is always the same”. This is doe to this number is a counter. In the first set of numbers there are 4 files (so the number of the first columns is 4...

Rafa_Ramos · May 28, 2021

Finally I made a formula field like this: SUM({Monday}, {Tuesday}, {Wednesday}, {Thursday}, {Friday}) * 60 and I assigned the formatting (format: duration, duration format: h:mm). Example: Monday=1440, Tuesday=30, and the other days are equal to 0. R...

User Statistics

User Activity

How to operate formulas with specific cells?

SUM of several MINUTES and transform the sum into HOURS

Re: How to operate formulas with specific cells?

Re: SUM of several MINUTES and transform the sum into HOURS