Terry - You could try a formula like thi

Written by Craig.

Terry - You could try a formula like this =TIME(ROUNDDOWN(24.*([Date2]-[Date1]),0),ROUNDDOWN(MOD(24.*60*([Date2]-[Date1]),60),0),MOD(24.*60*60*([Date2]-[Date1]),60)) And then format the column as H:mm:ss But that would not account for the correct number of hours if the gap is larger than 23.9999999 hours because there aren't more than 24 hours in a "time" field.