sample.xlsx

<div>
<div class="content wysiwyg-content">
Hi, I have the below values in my cell in excel where 2.89s means 2 minutes and 89 seconds. Now<br />
I have to find the average in minutes or seconds. Can any one please give me that formula in excel <br />
to get average in minutes and seperately in seconds as well ?<br />
<br />
2.89s<br />
3.08s<br />
2.26s<br />
2.05s<br />
2.25s<br />
<br />
Many Thanks
</div>
</div>


Hi, I have the below values in my cell in excel where 2.89s means 2 minutes and 89 seconds. Now
I have to find the average in minutes or seconds. Can any one please give me that formula in excel 
to get average in minutes and seperately in seconds as well ?

2.89s
3.08s
2.26s
2.05s
2.25s

Many Thanks

Excel Time calculation

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.