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
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
How to calculate No. of days & remaining days between two day?
0
Discussion
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".
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
Answers
0
Selected Answer
I got the answer (See attachment for answer)
Is there anyone who can put/perfrom all my caluclation in one cell?
Discussion
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: 1989) May 10, '17 at 3:18 am
Thank you, I got it :)
narendra_749yahoocom (rep: 14) Jun 3, '17 at 1:13 am