i want date & time calculation in excel. im herewith attaching sample excel file
SL NONAMEDATE OF DEATHTIME OF DEATHDATE CALL CENTRETIME CALL CENTREDATE BIMA MITRATIME BIMA MITRADATE OF AMOUNT GIVENTIME OF AMOUNT GIVENTOTAL TIME TAKEN FOR DISPOSAL OF AMOUNT
1234567891011
1aa14-03-20109.50 AM14-03-201010.50 AM14-03-201010.55 AM14-03-201010.55 AM
2bb18-03-201011.55 AM18-03-201011.35 AM18-03-201011.55 AM18-03-201011.55 AM
3cc21-02-200901.15 PM22-02-200901.15 AM23-02-200901.45 AM21-02-200901.45 AM
4dd15-01-200908.45 PM18-01-200908.45 AM19-01-200910.45 AM15-01-200910.45 AM
WHAT I WANT IS TOTAL TIME TAKEN FOR DISPOSING THE AMOUNT TO THE NOMINEE OF DISEASED. IT MAY TAKE MORE THAN 24 HOURS TO DISPOSE THE AMOUNT, i.e., column no. 10 (minus) column 4
SL NONAMEDATE OF DEATHTIME OF DEATHDATE CALL CENTRETIME CALL CENTREDATE BIMA MITRATIME BIMA MITRADATE OF AMOUNT GIVENTIME OF AMOUNT GIVENTOTAL TIME TAKEN FOR DISPOSAL OF AMOUNT
1234567891011
1aa14-03-20109.50 AM14-03-201010.50 AM14-03-201010.55 AM14-03-201010.55 AM
2bb18-03-201011.55 AM18-03-201011.35 AM18-03-201011.55 AM18-03-201011.55 AM
3cc21-02-200901.15 PM22-02-200901.15 AM23-02-200901.45 AM21-02-200901.45 AM
4dd15-01-200908.45 PM18-01-200908.45 AM19-01-200910.45 AM15-01-200910.45 AM
WHAT I WANT IS TOTAL TIME TAKEN FOR DISPOSING THE AMOUNT TO THE NOMINEE OF DISEASED. IT MAY TAKE MORE THAN 24 HOURS TO DISPOSE THE AMOUNT, i.e., column no. 10 (minus) column 4