How to calculate days:Hours:Minutes:
NOW she tells us that she has to do 500-1000 cells! Do you have a formula that
will handle that vbg ?
On Sat, 31 Jul 2004 22:50:52 -0400, "Daniel.M"
wrote:
Hi,
Just to clarify what you said in regards to being able to use
'1 Days, 2 Hrs, 23 Min' the same as '01 Days, 02 Hrs, 23 Min'...
The formula would have to be greatly modified to take into
account those entries which have a single digit (1) as opposed to two
digits
(01)?
If you still insist in a formula solution:
=INT(AVERAGE(MMULT(SUBSTITUTE(MID(A1:A2,SEARCH({" days","hr","min"},
A1)-3,3),",","")/{1,24,1440},{1;1;1})))& "_Days,_" &
TEXT(AVERAGE(MMULT(SUBSTITUTE(MID(A1:A2,SEARCH({" days","hr","min"},
A1)-3,3),",","")/{1,24,1440},{1;1;1})),"hh""_Hr,_""mm""_Min""")
Regards,
Daniel M.
|