|
Mike Buess
USA
3037 Posts |
 Posted - 08/23/2006 : 10:46:12 PM
|
Hi Angela,
This script will work as long as hour, min and sec columns are 1, 2 and 3...
wks.col=4;
wks.insert(Time); // insert Time col at position 4
loop(i,1,4) {wks.col$(i).format=2}; // format cols 1-4 as Text
loop(i,1,wks.maxrows) {
%Z=col(1)[i]$;
%A=col(2)[i]$;
%Z=%Z:%A;
%A=col(3)[i]$;
%Z=%Z:%A;
col(4)[i]$=%Z;
};
repeat 3 {del col(1)}; // delete first 3 cols
wks.col1.format=3; // format col 1 as Time
wks.col1.subformat=11; // subformat hh:mm:ss.###
Mike Buess
Origin WebRing Member |
 |
|
Combining hh mm ss into one cell
