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:
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
Post a Comment