Joined: 13 Jul 2007
Location: United States
Online Status: Offline
Posts: 1
Topic: Calculating Difference between two time fields Posted: 13 Jul 2007 at 1:58pm
I need a formula to calculate the difference in Hours and Minutes between two times. Example: Table name = PerryShipList and the fields that need to be calculated are: [Picked] = 1:15 PM [Shipped] = 1:44 PM. I need the formula create a calculated field called [Loading Time] which equals 0:29. I know the fomula that makes this work in Access (=HoursAndMinutes([Shipped]-[Picked]) but I need to write a Crystal report. Help!
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
