View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve Hud
 
Posts: n/a
Default Difference in dates calculations except between certain times.

I am trying to calculate the difference between two date/time entries in
minutes excluding a certain period of time.

EG date 1:- 1/10/2006 19:30; date 2:- 1/11/2006 10:00. i am aware that the
formula for calculating out the minutes is =(2nd date-1st date)*1440 which
returns the answer 870 but i am trying to exclude the time between 23:00 and
07:00 the following morning so i would like the answer to return 390 minutes.
The formula would have to work between multiple days such as 1/10/2006 -
4/01/2006 i.e a spilt of 3 days but excluding the times 23:00 to 07:00 as
above.

Please advise.