linux - OpenOffice Calc time conversion -


i profiling programs using "time" command on linux. outputted results in format this: 1m48.952s

now tabulate , graph collected data it's not easy when it's in format.

i have 2 questions: 1. there way convert format solely pure seconds. perhaps openoffice calc function? 2. there way call "time" command output in seconds , not minutes-seconds.

thank much

well tagged excel, here's excel solution:

=if(iserror(find("m",a1)),value(left(a1,find("s",a1)-1)), left(a1,find("m",a1)-1)*60+mid(a1,find("m",a1)+1,find("s",a1)-find("m",a1)-1))

it's simple formula translate directly open office. here's sample results:

enter image description here

as second question, man time explains can -f format output. description of how set format string in link. believe want -f %e elapsed real time (in seconds). default appears %e elapsed real time (in [hours:]minutes:seconds).


Comments

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

c++ - Is it possible to compile a VST on linux? -

url - Querystring manipulation of email Address in PHP -