Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I calculate duration between two dates and times in excel? | Excel Discussion (Misc queries) | |||
formula to calculate difference between dates and times | Excel Discussion (Misc queries) | |||
calculate elapsed time between dates and times | Excel Worksheet Functions | |||
Subtracting dates to get hours... but I want to skip weekends | Excel Discussion (Misc queries) | |||
Formula to calculate elapsed time between certain dates and times | Excel Discussion (Misc queries) |