Convert mm to hh:mm I am using `awk` to get all of the 4th comma-delimited fields, which is a duration in minutes. The required output is in the format of hh:mm, so I need to convert that from minutes. "...--prophetes.ai

Convert mm to hh:mm I am using `awk` to get all of the 4th comma-delimited fields, which is a duration in minutes. The required output is in the format of hh:mm, so I need to convert that from minutes. "jone","spdb-deploy","SD",25 "abrham","Data-deploy","DD",5 "crater","aps-deploy","AD",25 "valu","Platform-deploy","PD",5 "kiol","teer-deploy","TD",180 $ cat dat.csv | awk -F',' '{print $4}' 25 5 25 5 180 ...above values are in minutes, I want those values to be printed as hh:mm like below: 00:25 00:05 00:25 00:05 03:00

Use the formatted printing function, like

> awk -F, '{$4 = sprintf("%02d:%02d", int($4/60), $4%60)}1' OFS=, file
"jone","spdb-deploy","SD",00:25
"abrham","Data-deploy","DD",00:05
"crater","aps-deploy","AD",00:25
"valu","Platform-deploy","PD",00:05
"kiol","teer-deploy","TD",03:00