Calculating Elapsed Time

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.
 
B

Biff

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate elapsed time excluding specific timeframe 10
Need formula for time between two events 5
calculate elapsed time between dates and times 2
Access Access - Elapsed Time between Records 5
Calculate how much time falls between set start and stop times 15
Calculating Elapsed Time 2
Formula for elapsed time 3
Elapsed Time Formula 6

Top