• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Fetching Value

sambit

Member
Sir,
please help to resolve the following issue.

Data look like below
DateStart TimeEnd TimeValue
10-04-2018​
06:3009:4013
10-04-2018​
09:4110:4061
11-04-2018​
10:5011:4030
12-04-2018​
11:4112:5041
12-04-2018​
12:5114:4032
11-04-2018​
14:4115:4079



Required output like below
DateTimeValue
10-04-201807:3013
10-04-201808:3013
11-04-201810:5530
11-04-201811:0030
11-04-201811:3530
 

Attachments

  • Example file.xlsx
    9.3 KB · Views: 3
Back
Top