2 Replies Latest reply on Dec 14, 2012 11:30 AM by brian.curran

    Calculating Date and Time, spanning midnight too...

    brian.curran

      Title

      Calculating Date and Time, spanning midnight too...

      Post

           Hi,
           I have an 'Incidents' table that needs some calculation fields adding to it:

           Fields:
           CalledDate
           CalledTime
           ArrivedDate
           ArrivedTime
           DepartedDate
           DepartedTime

           I want to calculate how many minutes it took from the date and time we were Called to when we Arrived. Then, how many minutes we were on Site for (Departed - Arrived).

           Should I be looking at creating a Calculation field with a TimeStamp type to combine the 'Date' and 'Time' fields? We work 24 hours a day so we need to account for Incidents that span midnight.

           Thanks
           Brian.