|
-
Jun 12th, 2006, 07:19 AM
#1
Thread Starter
New Member
Need function that will return amount of time between two timestamps.
I looking for a function that I can use to enter two timestamps and return the amount of time between them (in minutes).
Parameters are:
Excel Cells will be formatted as follows (dd/mm/ccyy hh/mm/ss AM/PM)
Do not include weekends in the calculation.
Do not include the time between 5pm and 8am in the calculations.
For example the values in the two cells may be:
6/16/2006 1:46:14 PM
6/19/2006 2:01:40 PM
What it should return is 552 minutes and 6 seconds.(or 552.1)
Does anyone know of a macro that does this or the code needed to build one?
Thanks,
DD.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|