Access 2010:
I need to calc the difference between two times then calc a percentage of an hour?
 !StartTimeStamp1 = StartTime

!EndTimeStamp1 = MDrs("TimeStamp1")

!Total_time = MDrs("TimeStamp1")  StartTime
First problem, the above code is giving the following result, adding 12 hours when the difference is less than one hour. See attachment.
Second problem I cannot find a good example to calc a percentage of an hour. i.e. if the above field "Total_time" = 29:51 then I want to calc 29:51 / 60:00 = .4975
Hope I explained my problem correctly