Code:
[mind@util1-pkl MHG_201406]$ cat Pax.csv
AccountCode,AccountName,UniqueCallId,FromNumber,ToNumber,DestinationDescription,CallType,CallDate,CallTime,CallDuration,CallDurationSec,Cost,TelkomAsIf
563416,MHG - Braamfontein,3260306859:0A,0860101380,0214805963,Cape Town area,VoIS Contact Sharecall Overflow,20-JUN-2014,17:03:56,00:00:05,5,.0125,0.5
563416,MHG - Braamfontein,3275326523:0A,0860101380,0214805963,Cape Town area,VoIS Contact Sharecall Overflow,23-JUN-2014,14:19:07,00:00:20,20,.05,0.5
563416,MHG - Braamfontein,3280178113:0A,0860101380,0214805963,Cape Town area,VoIS Contact Sharecall Overflow,24-JUN-2014,08:06:23,00:00:06,6,.015,0.5
563416,MHG - Braamfontein,3305018045:0A,0860101380,0214805963,Cape Town area,VoIS Contact Sharecall Overflow,26-JUN-2014,10:32:13,00:00:06,6,.015,0.5
563416,MHG - Braamfontein,3305020549:0A,0860101380,0214805963,Cape Town area,VoIS Contact Sharecall Overflow,26-JUN-2014,10:32:22,00:00:04,4,.01,0.5
563416,MHG - Braamfontein,3064064999:0A,0860101380,0214805963,Cape Town area,VoIS Contact Sharecall Overflow,28-MAY-2014,12:05:07,00:00:06,6,.015,0.5
563416,MHG - Braamfontein,3071554761:0A,0860101380,0214805963,Cape Town area,VoIS Contact Sharecall Overflow,29-MAY-2014,09:12:05,00:00:20,20,.05,0.5
563416,MHG - Braamfontein,3076236709:0A,0860101280,0113812027,Johannesburg area,VoIS Contact Sharecall Overflow,29-MAY-2014,14:07:51,00:00:01,1,.0025,0.5
563416,MHG - Braamfontein,3082567491:0A,0860101380,0214805963,Cape Town area,VoIS Contact Sharecall Overflow,30-MAY-2014,10:00:47,00:00:07,7,.0175,0.5
661178,MHG - Cape Town,3257924103:0A,0860102472,0214804774,Cape Town area,VoIS Contact Sharecall Overflow,20-JUN-2014,14:07:13,00:00:16,16,.04,0.5
661178,MHG - Cape Town,3059920319:1830,0214804511,0860765633,Telkom Non-Geographic Universal Services,VoIS Community Sharecall,28-MAY-2014,10:52:34,00:10:52,652,1.8473,2.7167
661178,MHG - Cape Town,3059920319:1890,0214804511,0860104111,Telkom Non-Geographic Universal Services,VoIS Community Sharecall,28-MAY-2014,10:57:09,00:10:01,601,1.7028,2.5042
661178,MHG - Cape Town,3070357179:360,0214804511,0860765633,Telkom Non-Geographic Universal Services,VoIS Community Sharecall,29-MAY-2014,08:46:20,00:20:39,1239,3.5105,5.1625
661178,MHG - Cape Town,3070357179:824,0214804511,0860765633,Telkom Non-Geographic Universal Services,VoIS Community Sharecall,29-MAY-2014,09:35:03,00:18:44,1124,3.1847,4.6833
661178,MHG - Cape Town,3070357179:1103,0214804511,0860765633,Telkom Non-Geographic Universal Services,VoIS Community Sharecall,29-MAY-2014,10:03:07,00:00:48,48,.136,0.2
661178,MHG - Cape Town,3070357179:4351,0214804511,0860765633,Telkom Non-Geographic Universal Services,VoIS Community Sharecall,29-MAY-2014,14:17:10,00:07:22,442,1.2523,1.8417
661178,MHG - Cape Town,3080634155:1403,0214804511,0860765633,Telkom Non-Geographic Universal Services,VoIS Community Sharecall,30-MAY-2014,10:28:53,00:04:43,283,.8018,1.1792
661178,MHG - Cape Town,3080634155:3172,0214804511,0860765633,Telkom Non-Geographic Universal Services,VoIS Community Sharecall,30-MAY-2014,13:01:29,00:06:22,382,1.0823,1.5917
661178,MHG - Cape Town,3080634155:3622,0214804511,0860765633,Telkom Non-Geographic Universal Services,VoIS Community Sharecall,30-MAY-2014,13:38:33,00:03:08,188,.5327,0.7833
661178,MHG - Cape Town,3080634155:3648,0214804511,0860765633,Telkom Non-Geographic Universal Services,VoIS Community Sharecall,30-MAY-2014,13:41:42,00:19:29,1169,3.3122,4.8708
[mind@util1-pkl MHG_201406]$ awk -F, -v OFS="," '
> $7 ~ /VoIS Community Sharecall/ { $12=($10*0.19)/60 }
> $7 ~ /VoIS Contact Sharecall Overflow/ { $12=($10*0.4)/60 }
> { $13=($13*0.5)/60 }
> { print }' Pax.csv > Pax_1.csv
[mind@util1-pkl MHG_201406]$ cat Pax_1.csv
AccountCode,AccountName,UniqueCallId,FromNumber,ToNumber,DestinationDescription,CallType,CallDate,CallTime,CallDuration,CallDurationSec,Cost,0
563416,MHG - Braamfontein,3260306859:0A,0860101380,0214805963,Cape Town area,VoIS Contact Sharecall Overflow,20-JUN-2014,17:03:56,00:00:05,5,0,0.00416667
563416,MHG - Braamfontein,3275326523:0A,0860101380,0214805963,Cape Town area,VoIS Contact Sharecall Overflow,23-JUN-2014,14:19:07,00:00:20,20,0,0.00416667
563416,MHG - Braamfontein,3280178113:0A,0860101380,0214805963,Cape Town area,VoIS Contact Sharecall Overflow,24-JUN-2014,08:06:23,00:00:06,6,0,0.00416667
563416,MHG - Braamfontein,3305018045:0A,0860101380,0214805963,Cape Town area,VoIS Contact Sharecall Overflow,26-JUN-2014,10:32:13,00:00:06,6,0,0.00416667
563416,MHG - Braamfontein,3305020549:0A,0860101380,0214805963,Cape Town area,VoIS Contact Sharecall Overflow,26-JUN-2014,10:32:22,00:00:04,4,0,0.00416667
563416,MHG - Braamfontein,3064064999:0A,0860101380,0214805963,Cape Town area,VoIS Contact Sharecall Overflow,28-MAY-2014,12:05:07,00:00:06,6,0,0.00416667
563416,MHG - Braamfontein,3071554761:0A,0860101380,0214805963,Cape Town area,VoIS Contact Sharecall Overflow,29-MAY-2014,09:12:05,00:00:20,20,0,0.00416667
563416,MHG - Braamfontein,3076236709:0A,0860101280,0113812027,Johannesburg area,VoIS Contact Sharecall Overflow,29-MAY-2014,14:07:51,00:00:01,1,0,0.00416667
563416,MHG - Braamfontein,3082567491:0A,0860101380,0214805963,Cape Town area,VoIS Contact Sharecall Overflow,30-MAY-2014,10:00:47,00:00:07,7,0,0.00416667
661178,MHG - Cape Town,3257924103:0A,0860102472,0214804774,Cape Town area,VoIS Contact Sharecall Overflow,20-JUN-2014,14:07:13,00:00:16,16,0,0.00416667
661178,MHG - Cape Town,3059920319:1830,0214804511,0860765633,Telkom Non-Geographic Universal Services,VoIS Community Sharecall,28-MAY-2014,10:52:34,00:10:52,652,0,0.0226392
661178,MHG - Cape Town,3059920319:1890,0214804511,0860104111,Telkom Non-Geographic Universal Services,VoIS Community Sharecall,28-MAY-2014,10:57:09,00:10:01,601,0,0.0208683
661178,MHG - Cape Town,3070357179:360,0214804511,0860765633,Telkom Non-Geographic Universal Services,VoIS Community Sharecall,29-MAY-2014,08:46:20,00:20:39,1239,0,0.0430208
661178,MHG - Cape Town,3070357179:824,0214804511,0860765633,Telkom Non-Geographic Universal Services,VoIS Community Sharecall,29-MAY-2014,09:35:03,00:18:44,1124,0,0.0390275
661178,MHG - Cape Town,3070357179:1103,0214804511,0860765633,Telkom Non-Geographic Universal Services,VoIS Community Sharecall,29-MAY-2014,10:03:07,00:00:48,48,0,0.00166667
661178,MHG - Cape Town,3070357179:4351,0214804511,0860765633,Telkom Non-Geographic Universal Services,VoIS Community Sharecall,29-MAY-2014,14:17:10,00:07:22,442,0,0.0153475
661178,MHG - Cape Town,3080634155:1403,0214804511,0860765633,Telkom Non-Geographic Universal Services,VoIS Community Sharecall,30-MAY-2014,10:28:53,00:04:43,283,0,0.00982667
661178,MHG - Cape Town,3080634155:3172,0214804511,0860765633,Telkom Non-Geographic Universal Services,VoIS Community Sharecall,30-MAY-2014,13:01:29,00:06:22,382,0,0.0132642
661178,MHG - Cape Town,3080634155:3622,0214804511,0860765633,Telkom Non-Geographic Universal Services,VoIS Community Sharecall,30-MAY-2014,13:38:33,00:03:08,188,0,0.0065275
661178,MHG - Cape Town,3080634155:3648,0214804511,0860765633,Telkom Non-Geographic Universal Services,VoIS Community Sharecall,30-MAY-2014,13:41:42,00:19:29,1169,0,0.04059
[mind@util1-pkl MHG_201406]$