The following formula will give the volume of the contents of a horizontal cylinder.
=0.5*ra*ra*(2*ACOS((ra-de)/ra)-SIN(2*ACOS((ra-de)/ra)))*le/1000000
Just paste this into a spreadsheet
"ra" is the radius of the cylinder
"de" is the depth of the contents (ie diameter minus...