Adding Minutes second and Tenths of seconds

[OhioPest]

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 total minutes.
Thanks

 

[ajetrumpet]

how many seconds are there in a minute?

how many tenths of a second are there in a minute?

answer: 60 secs

answer: 60 secs * 10 tenths of a sec = 600 tenths of a sec per minute



thus, the next column would be:

SELECT

([minutes] +

([seconds] / 60) +

([tenths of a second] / 600))

as [Total Minutes]

 

[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)