Convert Scientific notation into Decimal values.

The formula was to calc the diff between send and recieve times where they were both >0
otherwise put "" .. this way its ignored by the xl AVERAGE Function; that data is in Column T and the =AVERAGE(T2:T26877) is in cell T1.Please see the spreadsheet attached.Please help me write the formula for above requirement in the spreadsheet attached and convert all the columns with scientific notation to decimal values,your help is highly appreciated.

1/ You posted a csv file, not an excel format.... it just has data within.

2/ the scientific notation within CSV is automatically converted to a "number" when csv opened in excel. In an excel file, you still see the Exponent format only because the cell width is small. Widen the cell and it shows 1280000000000000000

3/ All your time values are the same in the CSV... 1280000000000000000; also no need to send so much data, 5 lines would often be enough for testing.

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …

If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you!
In this Micro Tutorial, you'll learn yo…

Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…