Hi, I need your help. How can I calculate the TOTAL MINUTES depending on the TIME IN where the type field is equal to START GAME
Thanks
Hello,
Do you mean you need a formula to calculate (TIME OUT - TIME IN) if type = START GAME?
yes correct
Yes correct
Ok, then i guess you can use the following formula in the TOTAL MINUTES column (G2):
if(C2=“START GAME”,F2-E2,“”)
this means that if the value in column C2(Type) is equal to “START GAME”, the value in column G2 (TOTAL MINUTES) is the difference between “TIME OUT” and “TIME IN”.
If you go to the TOTAL MINUTES column settings in Appsheet, you will find the formula in Auto Compute → Spreadsheet formula.
Thanks!
it work in first line but next lines doesn’t work. how can i put to all the lines
Hello,
You have to be sure the formula is loaded in Auto Compute → Spreadsheet formula. Try to regenerate the schema of your table (press the circular arrow).