Calculate Headway Deviation 1

[capronton]

I have the data set below and I would like to calculate headway deviation (actual headway - schedule headway)

tDate [/indent]incTime schTime bus HeadwayDeviation
3/23/16 6:39:30 6:37 5015 ?
3/23/16 6:47:30 6:49 5012 ?
3/23/16 7:02:30 7:01 5007 ?
3/23/16 7:34:30 7:26 5022 ?
3/23/16 7:38:30 7:38 5006
3/23/16 7:55:31 7:50 5017
3/23/16 8:10:32 8:05 5003
3/23/16 8:28:31 8:17 5013
3/23/16 9:27:32 9:22 5010
3/23/16 9:37:32 9:35 5019
3/23/16 9:43:32 8:30 5009

Formula for ActualHeadway
previous(incTime) - incTime

Formula for ScheduleHeadway
previous(schTime) - schTime

Formula for HeadwayDeviation
ActualHeadway - ScheduleHeadway

Can someone assist me in creating the 3 formulas above based on data set?

Thanks in advance for assistance.

 

[CrystalizeCanada]

You're welcome - glad its working

Gordon BOCP
Crystalize