AnsweredAssumed Answered

Calculating Date and Time, spanning midnight too...

Question asked by brian.curran on Dec 14, 2012
Latest reply on Dec 14, 2012 by 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.

Outcomes