Jeremy Member

• Activity
• Posts5
• Comments8

• Time Differential

  Jeremy

  December 2017
  I'm trying to calculate how much time on average an employee spends at a location. We have a clock in and clock out time. Currently, I have the forumula set up as: SEC_TO_TIME(Avg(TIME_TO_SEC(`Time O…
  1

• How can I take multiple columns and create new rows based on the data?

  Jeremy

  April 2018
  We input some data through a form that is very limited in how it organizes the data. It currently looks similar to this (these are the column headers): Date / Manager / State / District / Site / Type…
  1

• Re: Count Summary Number

  Jeremy

  November 2017
  Took a bit (have to love huge files) but this is working. Thanks for steering me in the right direction.
  1

• Re: How can I take multiple columns and create new rows based on the data?

  Jeremy

  April 2018
  Correct. I'm trying to do it all within there as I am making some other changes as well.
  1

• Re: How can I take multiple columns and create new rows based on the data?

  Jeremy

  April 2018
  I should have thought of that. That's perfect. Thanks so much for the help.
  1

Next