Time formating

03/31/21
Accepted

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...

Best Answer

  • Paul NewcomePaul Newcome ✭✭✭✭✭
    Accepted Answer

    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.

    thinkspi.com

Answers

  • Paul NewcomePaul Newcome ✭✭✭✭✭

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

    thinkspi.com

  • 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 NewcomePaul Newcome ✭✭✭✭✭
    Accepted Answer

    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.

    thinkspi.com

  • Thank you very much!

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Happy to help. 👍️

    thinkspi.com

Sign In or Register to comment.