Hello,
Start date Start time End date End time Difference in Days
01.05.2016 04.25 PM 01/05/2016 06.15 PM ---
Blank Cell 06/05/2016 11.00 AM 05 DAYS (Expected Result)
02.05.2016 08.50 AM 02/05/2016 09.00 AM ---
Blank Cell 03/05/2016 09.00 AM ---
Blank Cell 09/05/2016 09.00 AM ---
Blank Cell 15/05/2016 06.20 PM 13 DAYS (Expected Result)
Please help me in above question.
I have attached one excel file in that file there is some data and also there is expected result is also given, but i want the formula so that we can do it quickly.