LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default Calculate number of hours between dates and times excluding Weekends

Hi I need to calculate the number of hours between two dates and times
excluding weekends. I would assume this requires a VB code but not too
familar with it, can anyone help.

For .e.g:

Start Date: - 23/10/06 12:30
End Date: - 25/10/06 11:30

The code should calculate if the difference is 24 hours or more and
display a message Exceeded or if it is less say not exceeded but if it
has crossed over the weekend then say, Weekend.

Can anyon please help!!!

Thanks
Princy

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I calculate duration between two dates and times in excel? Robin CSM002 Excel Discussion (Misc queries) 3 May 13th 23 07:42 PM
formula to calculate difference between dates and times Breezie Excel Discussion (Misc queries) 2 February 25th 06 04:14 PM
calculate elapsed time between dates and times Jenna Excel Worksheet Functions 2 January 25th 06 04:39 PM
Subtracting dates to get hours... but I want to skip weekends shadestreet Excel Discussion (Misc queries) 2 October 5th 05 06:20 PM
Formula to calculate elapsed time between certain dates and times Stadinx Excel Discussion (Misc queries) 6 March 25th 05 07:02 AM


All times are GMT +1. The time now is 08:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"