seanmorris
asked on
Calculate number of hours between two datetime fields
I need to calculate the number of huors between two datetimes. Furthermore i need to exlude weekends.
e.g.
C E
19/10/2006 19:39 23/10/2006 08:00
18/04/2007 00:04 18/04/2007 08:00
31/07/2007 20:03 01/08/2007 08:00
31/07/2007 19:27 01/08/2007 08:00
31/07/2007 20:36 01/08/2007 08:00
31/07/2007 19:45 01/08/2007 15:59
31/07/2007 18:09 01/08/2007 08:00
31/07/2007 20:24 01/08/2007 08:00
I can calulate the number of days using networkday, but i can quite figure out the number of hours.
e.g.
C E
19/10/2006 19:39 23/10/2006 08:00
18/04/2007 00:04 18/04/2007 08:00
31/07/2007 20:03 01/08/2007 08:00
31/07/2007 19:27 01/08/2007 08:00
31/07/2007 20:36 01/08/2007 08:00
31/07/2007 19:45 01/08/2007 15:59
31/07/2007 18:09 01/08/2007 08:00
31/07/2007 20:24 01/08/2007 08:00
I can calulate the number of days using networkday, but i can quite figure out the number of hours.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks matthewspatrick
that is exactly what i was looking.
regards
sm
that is exactly what i was looking.
regards
sm
Just a question: Do C and E ever occur on weekends themselves. If not the solution is a lot easier.