LinkBack URL
About LinkBacks
I have a column G1:G6874 containing time values such as 00:00:01, 00:00:10, 00:00:07, 00:01:05, etc. I want to find the average of time greater than (and not equal to) 00:00:00 and less than (and equal to) 00:00:05.
Any help on that?
Thanks
I have a column G1:G6874 containing time values such as 00:00:01, 00:00:10, 00:00:07, 00:01:05, etc. I want to find the average of time greater than (and not equal to) 00:00:00 and less than (and equal to) 00:00:05.
Any help on that?
Thanks
Last edited by DexterG; 12-10-2012 at 07:21 AM.
Try..
or for 2007 and later versions
Please Login or Register to view this content.
Please Login or Register to view this content.
Life's a spreadsheet, Excel!
Say thanks, Click *
Hi Ace_XL,
That works. I need to do this across different time ranges, so I can modify the seconds and divide them by 86400.
But can formatting the cell (or tweaking the formula) help to directly use seconds such as 00:00:05 or 00:01:00? Just asking for information, might come handy sometime in future!
Thanks a ton!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks