Calculating Date and Time, spanning midnight too...
I have an 'Incidents' table that needs some calculation fields adding to it:
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.