Recent content by OhioPest

Thank you... I kind of figured it out in a round about way. A few extra steps but it worked the same way none the less. I did it in excel first and then figured it out in access. =SUM((((D16*60)+E16)+(F16*0.1))/60)

Hi, I have 3 columns the first being MINUTES, the second being SECONDS and the third being TENTHS of SECONDS. How would I combine these to show total minutes in whole minutes and seconds displayed at a decimal lever. EXAMPLE: 1 minute 47 seconds and 3 tenths of a second should equal 1.788333333...