Date time separation & calculation to get to total hh:mm

Hi, this nur again,
Cell A1 having date & time format like 20130307141900 . here the actual meaning is yyyymmddhhmmss
From here I want to separate date & time , which is like below
my first date time format like below, from here i want CELL B & CELL C as output results

Please Login or Register  to view this content.

my second date time is another format, cell D & cell E is input data , from here i want like cell F & cell G

Please Login or Register  to view this content.

3rd step:
After getting above format now I want to subtract from one date to other date to get the total hour & minute. Subtract will be from

Please Login or Register  to view this content.

Hi nur2544

To parse out the date and time, assuming in A1: 20130307141900
In B1: =DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2))
In C1: =TIME(MID(A1,9,2),MID(A1,11,2),RIGHT(A1,2))

Then you can subtract, add etc or whatever you want to do.

Hi Nur,

See the attached file where I used Date / Time function with text functions like left / mid / right to obtain your desired results :-

date time separation.xlsx

Regards,
DILIPandey
<click on below * if this helps>

Hi Nur2544,

Formula is correct, just change the format to [h]:mm


Regards,
DILIPandey
<click on below * if this helps>

you are welcome Nur2544.... cheers


Regards,
DILIPandey
<click on below * if this helps>