i am not able to calculate average time by using the Average function its giving error, can any one help me out
2007-03-02 05:46:38 · 4 answers · asked by Mahesh K 1 in Computers & Internet ➔ Software
I am trying to get average of following type of data (averge time taken)
00:15
00:15
12:30
11:00
11:00
11:00
2007-03-02 06:08:43 · update #1
Yes you can do this. I took the time figures you gave as example and put them in cells A1 through A6. Then in Cell B1 "=VALUE(A1)". Copy down to B6. Then in B7 "=AVERAGE(B1:B6)" and formatted B7 as "hh:mm".
Result is 7:40
Hope this helps,
Kind Regards,
QwertyKPH @ Yahoo
2007-03-03 13:24:51 · answer #1 · answered by qwertykph 4 · 1⤊ 0⤋
Hi,
This is easy, turn the dates back to numbers then find the average then turn it back into time formats. Hope this helps.
2007-03-02 05:54:26 · answer #2 · answered by Anonymous · 0⤊ 0⤋
Describe the data you are trying to average. Are they timestamps, just integers, or what? (And what is the exact error it is generating?)
2007-03-02 05:50:17 · answer #3 · answered by Cribbage 5 · 0⤊ 0⤋
reproduction the column the place you like. 0 happens, the completed column. backside good, click the arrow icon, decide on merchandise component 3, purely numbers. Column looks figures they / you downloaded.
2016-10-17 02:52:21 · answer #4 · answered by Anonymous · 0⤊ 0⤋