Calculate Date Difference with a criteria

**DBY** · 07-23-2013, 01:58 PM

Hello
I make it 55, with the following formula:

=A2-A1-DATEDIF(A1,A2,"d")*TIME(10,0,0)

Custom number format cell A3 as:

[h]:mm

.

Hope this helps.
DBY

**AlKey** · 07-23-2013, 02:38 PM

Questions for DBY: there are 3 days and 23 hours difference between these two dates. Why would there be 55 hours? Am I missing something?

**Pepe Le Mokko** · 07-23-2013, 02:47 PM

Originally Posted by AlKey

Questions for DBY: there are 3 days and 23 hours difference between these two dates. Why would there be 55 hours? Am I missing something?

OP asked that 10 hrs be deduced for each day in the period

@ioncila

Based on post #2, and with this in mind I get 45 hrs including the first and last day =A2-A1-(DATEDIF(A1,A2,"d")+1)*10/24
or 55 if the first day is omitted for deducing the 10 hrs =A2-A1-DATEDIF(A1,A2,"d")*10/24

( I replaced DBY's TIME(..) part by 10/24 which is of course the same )