How to calculate days:Hours:Minutes:
Addition to my previous response. Daniels Formula which he updated also produces the same difference when using the entries without preceeding 0's.
"Ron Rosenfeld" wrote:
On Sat, 31 Jul 2004 13:59:01 -0700, Kurewe
wrote:
Ron,
I have tried using the VBA routine and I get as far as inserting the module and pasting in the code. However, I have no experience with VBA and can get no further at the moment.
I unfortunately do not know if your suggestion will work.
To use the UDF:
1. Open your worksheet with the turn around time data
2. alt-F11 opens the Visual Basic Editor
3. Ensure your project is highlighted in the project explorer.
4. Insert/Module and then paste in the code from my previous message.
5. Then on the worksheet itself, enter a formula of the type
=AverageTimes(A2:A100)
(replace A2:A100 with the range where your data exists).
then Enter
If it works, the correct answer should appear.
--ron
|