Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Networkdays - differnce between 2 dates in Minutes; excluding weekend days

Status
Not open for further replies.

smmedeiros

Technical User
Feb 21, 2008
74
0
0
US
Looking for help to calculate the difference between 2 dates timestamps in number of minutes. I have a need to exclude weekends (Saturday & Sundays).
I'm familar with the use of Networkdays - however, that shows in days
I'm familiar with simple calculate =(b1-a1)*1440 .. however, this does not exclude weekends.

Need help combining the 2.

Thanks
 
SkipVought - Thanks for the idea. Do you have a sample how to code for this?
 
???

You stated you were familiar with NETWORKDAYS(). I don't understand your question.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top