0 - 2 of 2 tags for #Teradata #Sitescope #Linux #Scripting

What  all are possible ways to get the exact output mentioned below: start and endtime is timestamp fields ... In the final output starttime should take from status A and end time should take from status C .
Please help me
TAble A contains:
Name Status Start time and end time
A0001 A         08:00              08:10