time difference column

[andreas_lds]

At least at on my mobile phone your text is hardly readable. Please post the data we should work with in usable form: a data step with datalines.

[ChrisNZ]

> I want standard time format arrival and departure

What's not standard in the times you show?

>  also difference between two columns  timings

You have the duration already.

Or are these all text strings and you want to change them to SAS times?

Show us a proc contents.

[BrahmanandaRao]

please look into attachment 

i want output what  i mentioned

[Kurt_Bremser]

This is the SAS Communities. For help with Excel, consult Microsoft Support.

Please post your SAS dataset in usable form (a data step with datalines).

If I download an Excel file from the internet, my Chief Security Officer will nail my hide to the company door.

[Kurt_Bremser]

PS to calculate time differences, just subtract start from end time. SAS times are counts of seconds, so the result will be a SAS time value again. Assign the time5. format for proper display.

[ChrisNZ]

> please look into attachment 

No I will not.

1. MS office files are potentially dangerous.

2. The least you can do is make the effort to provide usable data and information.

> i want output what i mentioned

Good luck.