Calculating Elapsed Time

  • Thread starter Thread starter M. Owen
  • Start date Start date
M

M. Owen

Wanting to calculate in Excel the elapsed time in minutes, between two
dates and times and exclude weekends. For example, how much time
elapsed between 9-25-03 3:00PM and 9-30-03 9:00AM.
 
Hi M,

Here's one way:

Start date/time in A1.
End date/time in A2.

=(NETWORKDAYS(A1,A2)-SUM(MOD(A1,INT(A1)),1-MOD(A2,INT
(A2))))*1440

To make this really robust you would need to include the
[holidays] argument in the NETWORKDAYS function. That is
simlpy a list of holidays that you would also exclude from
the calculation.

Biff
 
Back
Top