how to derive wav file duration to put in a cell
i'll be switching to libre office from open office soon on one of my main computers. i have a simple spreadsheet on that machine that is, basically, a list of wav files and their descriptions. i'd like to include a column for the file durations. i already have a column that has the path to the file in the form of a hyperlink so that i can simply click to play the file. how would i derive the file durations and display them in a cell of the row that has each of these files?
for added info, the files are all the same format so that wouldn't be a variable. the only variable, as far as that goes, is that some are stereo and some are mono. when i enter the files into the list, though, i already include a column for mono/stereo so that could be used as a reference for a conditional statement since a stereo file would be twice the size of a mono one.
also, if it adds a lot of complication, the durations needn't be absolutely precise. i'd assume to get really precise numbers might mean drilling deeply into the files to be able to distinguish things like header info from audio data. i don't really care that much about that. i'd guess that, for my purposes, a formula would do. something like: if an hour of stereo audio is 650mb, then a 1.24mb file would be x duration, half that for mono.
thanks in advance,