AnsweredAssumed Answered

Calculate days worked based on Timestamps

Question asked by TedMorrill-Mccoure on Mar 11, 2013
Latest reply on Mar 11, 2013 by philmodjunk

Title

Calculate days worked based on Timestamps

Post

     I have a database for employees to record interviews as they perform them.  There is one record per interview, with a timestamp for when the record was created, an interviewer name, and the office location where the interview was performed.

     I want to be able to create a report showing the interviewer name, the office location, and how many days interviews were performed there.

     I created a report but can only get this kind of result..

     Interviewer one

                 Office one

                          3/4/2013 5:04:51 PM

                          3/5/2013 2:04:21 PM

     I'd like to see

      

     Interviewer one

                 Office one

                          2 days

     Anyone have any suggestions?

Outcomes