How to calculate No. of days & remaining days between two day?


How to calculate No. of days


Remaining days between two day using below format?

05/08/2017 10:20 AM IST

05/09/2017 11:20 AM IST



Sir Please help in this ...
iĀ Startup at 06/15/2017 21:30:18; and i Endup atĀ 06/17/2017 04:45:52 what are the total Number of Day Hours & What are the total Number of Night Hours, between these two dates? My day is between 5:00:00 & 23:00:00 & My night is between 23:00:00 & 05:00:00 Please help. Need the result as "Total Day Hours = hh:mm:ss; Total Night Hours = hh:mm:ss".
masdigravi (rep: 1) Jul 22, '17 at 7:09 am
Add to Discussion


Selected Answer

I got the answer (See attachment for answer)

Is there anyone who can put/perfrom all my caluclation in one cell?



You should update your original question with your new info/question so people can more easily see it or ask an entirely new question. The intention is to keep things clean and simple for future readers to follow.
don (rep: 1969) May 10, '17 at 3:18 am
Thank you, I got it :)
narendra_749yahoocom (rep: 14) Jun 3, '17 at 1:13 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login