R
relux
Hey guys,
Here is my situation. I have a formula in Column F that is:
=INT(D3-C3)&" days, "&INT(24*MOD(D3-C3,1))&" hours, an
"&ROUND(60*MOD(24*(D3-C3),1),0)&" minutes"
It takes the time from column c and d and shows the elapsed time. Wha
I need to do now is make a field in for example F 30 that shows th
average elapsed time. In other words, average up all the elapsed time
in Column F. I can't figure out a way to do this..
Also, I have the formula above all the way down the spreadsheet. I
there a way to hide "0 days, 0 hours, and 0 minutes" if there i
nothing in the C and D columns?
I've attached the spreadsheet..
Thanks in advance
+-------------------------------------------------------------------
|Filename: emails2.zip
|Download: http://www.excelforum.com/attachment.php?postid=3750
+-------------------------------------------------------------------
Here is my situation. I have a formula in Column F that is:
=INT(D3-C3)&" days, "&INT(24*MOD(D3-C3,1))&" hours, an
"&ROUND(60*MOD(24*(D3-C3),1),0)&" minutes"
It takes the time from column c and d and shows the elapsed time. Wha
I need to do now is make a field in for example F 30 that shows th
average elapsed time. In other words, average up all the elapsed time
in Column F. I can't figure out a way to do this..
Also, I have the formula above all the way down the spreadsheet. I
there a way to hide "0 days, 0 hours, and 0 minutes" if there i
nothing in the C and D columns?
I've attached the spreadsheet..
Thanks in advance
+-------------------------------------------------------------------
|Filename: emails2.zip
|Download: http://www.excelforum.com/attachment.php?postid=3750
+-------------------------------------------------------------------