I have four fields in a table:
Open date - format dd/mm/yy
Open time - format HH:MM
Close date - format dd/mm/yy
Close time - format HH:MM
I'd like to calculate in the fifth field the difference, in hours, between the open date & time and the close date & time. How am I best to do this?
Also, if i wanted to apply a working day rule to this (of 09:00 to 18:00) how could I then calculate this in days / hours.
The key question is whether or not you need the working day element - if you do then the approach is significantly different.
Total duration:
Working Day duration:
Please Login or Register to view this content.
use of NETWORKDAYS pre XL2007 requires activation of the Analysis ToolPak (tools - addins)Please Login or Register to view this content.
It would be helpful if you specified which version you're running either in post or profile [better] - and also your locale.
Last edited by DonkeyOte; 02-17-2011 at 07:28 AM. Reason: forgot note re: cumulative format
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks