Sir,
I have excel sheet in which I want to calculate the average of the time .kindly help me to calculate the average of each column.
Regards
Sir,
I have excel sheet in which I want to calculate the average of the time .kindly help me to calculate the average of each column.
Regards
I see your problem. none of the excel functions allow you to sum times.
I will look at creating a user defined function to do this for you.
But that will be these evening.
I think that we should be able to read all thedata in one column into an array three cells wideusung somthing
like:after that it should be quite simple to sum hours, mins,secondsPlease Login or Register to view this content.
and counti non zero vakues in one loop
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks