Time formating

Camyla Barbara Bezerra de Freitas

I would like to know if It's possible to format a field in hours and use formulas to calculate the difference between Finish and Start and to sum...

Paul Newcome

Take a look through THIS THREAD. In it there are multiple time based solutions, and there should be at least one that explains how to calculate the time difference. If you are needing help finding one that will work for you or tweaking one so that it does, feel free to let me know.

Paul Newcome

Are you able to provide a screenshot that has manually entered data to show what you are wanting to accomplish?

Camyla Barbara Bezerra de Freitas

I'm still creating this form. Now the total activity time is input manually through form, but I want my sheet to be able to calculate this time automatically. I'll also use this input in another sheet to calculate my cycle time and make it available in a dashboard.

Paul Newcome

Take a look through THIS THREAD. In it there are multiple time based solutions, and there should be at least one that explains how to calculate the time difference. If you are needing help finding one that will work for you or tweaking one so that it does, feel free to let me know.

Camyla Barbara Bezerra de Freitas

Thank you very much!

Paul Newcome

Happy to help. 👍️