Spreadsheet: 129937d1321979791-averaging-data-over-specified-time-excelhelpexample
Sheet: Sheet1

Date and Time | Battery | Voltage
2011-08-12 19:29:51 | 460 | 924
2011-08-12 19:29:52 | 460 | 928
2011-08-12 19:29:53 | 460 | 926
2011-08-12 19:29:54 | 460 | 925
2011-08-12 19:29:55 | 460 | 927
2011-08-12 19:29:56 | 460 | 930
2011-08-12 19:29:57 | 460 | 925
2011-08-12 19:29:58 | 460 | 927
2011-08-12 19:29:58 | 460 | 927
2011-08-12 19:29:59 | 460 | 923
2011-08-12 19:30:00 | 460 | 926
2011-08-12 19:30:01 | 460 | 926
2011-08-12 19:30:02 | 460 | 928
2011-08-12 19:30:03 | 460 | 924
2011-08-12 19:30:04 | 460 | 931
2011-08-12 19:30:05 | 460 | 925
2011-08-12 19:30:06 | 460 | 928
2011-08-12 19:30:07 | 460 | 929
2011-08-12 19:30:08 | 460 | 930
2011-08-12 19:30:09 | 460 | 925
2011-08-12 19:44:51 | 460 | 928
2011-08-12 19:44:52 | 460 | 928
2011-08-12 19:44:53 | 460 | 931
2011-08-12 19:44:54 | 460 | 933
2011-08-12 19:44:55 | 460 | 927
2011-08-12 19:44:56 | 460 | 927
2011-08-12 19:44:57 | 460 | 927
2011-08-12 19:44:58 | 460 | 930
2011-08-12 19:44:58 | 460 | 936
2011-08-12 19:44:59 | 460 | 932
2011-08-12 19:45:00 | 460 | 936
2011-08-12 19:45:01 | 460 | 928
2011-08-12 19:45:02 | 460 | 930
2011-08-12 19:45:03 | 460 | 928
2011-08-12 19:45:04 | 460 | 931
2011-08-12 19:45:05 | 460 | 932
2011-08-12 19:45:06 | 460 | 930
2011-08-12 19:45:07 | 460 | 931
2011-08-12 19:45:08 | 460 | 929
2011-08-12 19:45:09 | 460 | 925
2011-08-12 19:59:51 | 460 | 925
2011-08-12 19:59:52 | 460 | 931
2011-08-12 19:59:53 | 460 | 933
2011-08-12 19:59:54 | 460 | 926
2011-08-12 19:59:55 | 460 | 930
2011-08-12 19:59:56 | 460 | 928
2011-08-12 19:59:57 | 460 | 924
2011-08-12 19:59:58 | 460 | 931
2011-08-12 19:59:58 | 460 | 931
2011-08-12 19:59:59 | 460 | 930
2011-08-12 20:00:00 | 460 | 931
2011-08-12 20:00:01 | 460 | 931
2011-08-12 20:00:02 | 460 | 928
2011-08-12 20:00:03 | 460 | 934
2011-08-12 20:00:04 | 460 | 935
2011-08-12 20:00:05 | 460 | 932
2011-08-12 20:00:06 | 460 | 930
2011-08-12 20:00:07 | 460 | 930
2011-08-12 20:00:08 | 460 | 934
2011-08-12 20:00:09 | 460 | 937
2011-08-12 20:14:51 | 460 | 934
2011-08-12 20:14:52 | 460 | 934
2011-08-12 20:14:53 | 460 | 936
2011-08-12 20:14:54 | 460 | 943
2011-08-12 20:14:55 | 460 | 936
2011-08-12 20:14:56 | 460 | 937
2011-08-12 20:14:57 | 460 | 935
2011-08-12 20:14:58 | 460 | 935
2011-08-12 20:14:58 | 460 | 935
2011-08-12 20:14:59 | 460 | 939
2011-08-12 20:15:00 | 460 | 941
2011-08-12 20:15:01 | 460 | 933
2011-08-12 20:15:02 | 460 | 938
2011-08-12 20:15:03 | 460 | 936
2011-08-12 20:15:04 | 460 | 939
2011-08-12 20:15:05 | 460 | 936
2011-08-12 20:15:06 | 460 | 935
2011-08-12 20:15:07 | 460 | 940
2011-08-12 20:15:08 | 460 | 939
2011-08-12 20:15:09 | 460 | 931
2011-08-12 20:29:51 | 460 | 939
2011-08-12 20:29:52 | 460 | 936
2011-08-12 20:29:53 | 460 | 940
2011-08-12 20:29:54 | 460 | 931
2011-08-12 20:29:55 | 460 | 933
2011-08-12 20:29:56 | 460 | 937
2011-08-12 20:29:57 | 460 | 937
2011-08-12 20:29:58 | 460 | 937
2011-08-12 20:29:58 | 460 | 944
2011-08-12 20:29:59 | 460 | 937
2011-08-12 20:30:00 | 460 | 933
2011-08-12 20:30:01 | 460 | 935
2011-08-12 20:30:02 | 460 | 935
2011-08-12 20:30:03 | 460 | 940
2011-08-12 20:30:04 | 460 | 940
2011-08-12 20:30:05 | 460 | 936
2011-08-12 20:30:06 | 460 | 940
2011-08-12 20:30:07 | 460 | 936
2011-08-12 20:30:08 | 460 | 937
2011-08-12 20:30:09 | 460 | 936
2011-08-12 20:44:51 | 460 | 944
2011-08-12 20:44:52 | 460 | 948
2011-08-12 20:44:53 | 460 | 942
2011-08-12 20:44:54 | 460 | 942
2011-08-12 20:44:55 | 460 | 940
2011-08-12 20:44:56 | 460 | 943
2011-08-12 20:44:57 | 460 | 945
2011-08-12 20:44:58 | 460 | 945
2011-08-12 20:44:58 | 460 | 945
2011-08-12 20:44:59 | 460 | 942
2011-08-12 20:45:00 | 460 | 944
2011-08-12 20:45:01 | 460 | 948
2011-08-12 20:45:02 | 460 | 940
2011-08-12 20:45:03 | 460 | 940
2011-08-12 20:45:04 | 460 | 941
2011-08-12 20:45:05 | 460 | 945
2011-08-12 20:45:06 | 460 | 942
2011-08-12 20:45:07 | 460 | 948
2011-08-12 20:45:08 | 460 | 941
2011-08-12 20:45:09 | 460 | 945
2011-08-12 20:59:51 | 460 | 957
2011-08-12 20:59:52 | 460 | 956
2011-08-12 20:59:53 | 460 | 952
2011-08-12 20:59:54 | 460 | 953
2011-08-12 20:59:55 | 460 | 956
2011-08-12 20:59:56 | 460 | 951
2011-08-12 20:59:57 | 460 | 955
2011-08-12 20:59:58 | 460 | 951
2011-08-12 20:59:58 | 460 | 956
2011-08-12 20:59:59 | 460 | 956
2011-08-12 21:00:00 | 460 | 955
2011-08-12 21:00:01 | 460 | 953
2011-08-12 21:00:02 | 460 | 953
2011-08-12 21:00:03 | 460 | 953
2011-08-12 21:00:04 | 460 | 952
2011-08-12 21:00:05 | 460 | 958
2011-08-12 21:00:06 | 460 | 957
2011-08-12 21:00:07 | 460 | 956
2011-08-12 21:00:08 | 460 | 958
2011-08-12 21:00:09 | 460 | 956
2011-08-12 21:14:51 | 460 | 1002
2011-08-12 21:14:52 | 460 | 998
2011-08-12 21:14:53 | 460 | 997
2011-08-12 21:14:54 | 460 | 998
2011-08-12 21:14:55 | 460 | 996
2011-08-12 21:14:56 | 460 | 996
2011-08-12 21:14:57 | 460 | 1003
2011-08-12 21:14:58 | 460 | 1003
2011-08-12 21:14:58 | 460 | 998
2011-08-12 21:14:59 | 460 | 998
2011-08-12 21:15:00 | 460 | 1000
2011-08-12 21:15:01 | 460 | 997
2011-08-12 21:15:02 | 460 | 1004
2011-08-12 21:15:03 | 460 | 1001
2011-08-12 21:15:04 | 460 | 994
2011-08-12 21:15:05 | 460 | 1006
2011-08-12 21:15:06 | 460 | 1001
2011-08-12 21:15:07 | 460 | 999
2011-08-12 21:15:08 | 460 | 996
2011-08-12 21:15:09 | 460 | 1001
2011-08-12 21:29:51 | 460 | 987
2011-08-12 21:29:52 | 460 | 992
2011-08-12 21:29:53 | 460 | 988
2011-08-12 21:29:54 | 460 | 983
2011-08-12 21:29:55 | 460 | 993
2011-08-12 21:29:56 | 460 | 988
2011-08-12 21:29:57 | 460 | 992
2011-08-12 21:29:58 | 460 | 993
2011-08-12 21:29:58 | 460 | 994
2011-08-12 21:29:59 | 460 | 988
2011-08-12 21:30:00 | 460 | 995
2011-08-12 21:30:01 | 460 | 993
2011-08-12 21:30:02 | 460 | 988
2011-08-12 21:30:03 | 460 | 984
2011-08-12 21:30:04 | 460 | 983
2011-08-12 21:30:05 | 460 | 980
2011-08-12 21:30:06 | 460 | 981
2011-08-12 21:30:07 | 460 | 984
2011-08-12 21:30:08 | 460 | 981
2011-08-12 21:30:09 | 460 | 984
2011-08-12 21:44:51 | 460 | 966
2011-08-12 21:44:52 | 460 | 970
2011-08-12 21:44:53 | 460 | 967
2011-08-12 21:44:54 | 460 | 967
2011-08-12 21:44:55 | 460 | 963
2011-08-12 21:44:56 | 460 | 963
2011-08-12 21:44:57 | 460 | 959
2011-08-12 21:44:58 | 460 | 961
2011-08-12 21:44:58 | 460 | 962
2011-08-12 21:44:59 | 460 | 961
2011-08-12 21:45:00 | 460 | 967
2011-08-12 21:45:01 | 460 | 961
2011-08-12 21:45:02 | 460 | 961
2011-08-12 21:45:03 | 460 | 963
2011-08-12 21:45:04 | 460 | 962
2011-08-12 21:45:05 | 460 | 959
2011-08-12 21:45:06 | 460 | 959
2011-08-12 21:45:07 | 460 | 960
2011-08-12 21:45:08 | 460 | 958
2011-08-12 21:45:09 | 460 | 960
2011-08-12 21:59:51 | 460 | 963
2011-08-12 21:59:52 | 460 | 959
2011-08-12 21:59:53 | 460 | 958
2011-08-12 21:59:54 | 460 | 959
2011-08-12 21:59:55 | 460 | 962
2011-08-12 21:59:56 | 460 | 964
2011-08-12 21:59:57 | 460 | 964
2011-08-12 21:59:58 | 460 | 960
2011-08-12 21:59:58 | 460 | 955
2011-08-12 21:59:59 | 460 | 958
2011-08-12 22:00:00 | 460 | 963
2011-08-12 22:00:01 | 460 | 961
2011-08-12 22:00:02 | 460 | 962
2011-08-12 22:00:03 | 460 | 962
2011-08-12 22:00:04 | 460 | 965
2011-08-12 22:00:05 | 460 | 956
2011-08-12 22:00:06 | 460 | 962
2011-08-12 22:00:07 | 460 | 963
2011-08-12 22:00:08 | 460 | 963
2011-08-12 22:00:09 | 460 | 963
2011-08-12 22:14:51 | 460 | 956
2011-08-12 22:14:52 | 460 | 957
2011-08-12 22:14:53 | 460 | 961
2011-08-12 22:14:54 | 460 | 957
2011-08-12 22:14:55 | 460 | 958
2011-08-12 22:14:56 | 460 | 955
2011-08-12 22:14:57 | 460 | 962
2011-08-12 22:14:58 | 460 | 963
2011-08-12 22:14:58 | 460 | 962
2011-08-12 22:14:59 | 460 | 956
2011-08-12 22:15:00 | 460 | 960
2011-08-12 22:15:01 | 460 | 957
2011-08-12 22:15:02 | 460 | 960
2011-08-12 22:15:03 | 460 | 959
2011-08-12 22:15:04 | 460 | 956
2011-08-12 22:15:05 | 460 | 957
2011-08-12 22:15:06 | 460 | 958
2011-08-12 22:15:07 | 460 | 961
2011-08-12 22:15:08 | 460 | 967
2011-08-12 22:15:09 | 460 | 960
2011-08-12 22:29:51 | 460 | 976
2011-08-12 22:29:52 | 460 | 977
2011-08-12 22:29:53 | 460 | 975
2011-08-12 22:29:54 | 460 | 974
2011-08-12 22:29:55 | 460 | 974
2011-08-12 22:29:56 | 460 | 971
2011-08-12 22:29:57 | 460 | 974
2011-08-12 22:29:58 | 460 | 977
2011-08-12 22:29:58 | 460 | 975
2011-08-12 22:29:59 | 460 | 980
2011-08-12 22:30:00 | 460 | 976
2011-08-12 22:30:01 | 460 | 977
2011-08-12 22:30:02 | 460 | 979
2011-08-12 22:30:03 | 460 | 975
2011-08-12 22:30:04 | 460 | 978
2011-08-12 22:30:05 | 460 | 971
2011-08-12 22:30:06 | 460 | 977
2011-08-12 22:30:07 | 460 | 977
2011-08-12 22:30:08 | 460 | 972
2011-08-12 22:30:09 | 460 | 969
2011-08-12 22:44:51 | 460 | 974
2011-08-12 22:44:52 | 460 | 978
2011-08-12 22:44:53 | 460 | 978
2011-08-12 22:44:54 | 460 | 977
2011-08-12 22:44:55 | 460 | 973
2011-08-12 22:44:56 | 460 | 973
2011-08-12 22:44:57 | 460 | 977
2011-08-12 22:44:58 | 460 | 974
2011-08-12 22:44:58 | 460 | 983
2011-08-12 22:44:59 | 460 | 975
2011-08-12 22:45:00 | 460 | 978
2011-08-12 22:45:01 | 460 | 978
2011-08-12 22:45:02 | 460 | 979
2011-08-12 22:45:03 | 460 | 979
2011-08-12 22:45:04 | 460 | 969
2011-08-12 22:45:05 | 460 | 972
2011-08-12 22:45:06 | 460 | 977
2011-08-12 22:45:07 | 460 | 978
2011-08-12 22:45:08 | 460 | 976
2011-08-12 22:45:09 | 460 | 971
2011-08-12 22:59:51 | 460 | 991
2011-08-12 22:59:52 | 460 | 983
2011-08-12 22:59:53 | 460 | 990
2011-08-12 22:59:54 | 460 | 989
2011-08-12 22:59:55 | 460 | 988
2011-08-12 22:59:56 | 460 | 986
2011-08-12 22:59:57 | 460 | 993
2011-08-12 22:59:58 | 460 | 990
2011-08-12 22:59:58 | 460 | 986
2011-08-12 22:59:59 | 460 | 989
2011-08-12 23:00:00 | 460 | 991
2011-08-12 23:00:01 | 460 | 991
2011-08-12 23:00:02 | 460 | 990
2011-08-12 23:00:03 | 460 | 994
2011-08-12 23:00:04 | 460 | 987
2011-08-12 23:00:05 | 460 | 992
2011-08-12 23:00:06 | 460 | 990
2011-08-12 23:00:07 | 460 | 990
2011-08-12 23:00:08 | 460 | 989
2011-08-12 23:00:09 | 460 | 988
2011-08-12 23:14:51 | 460 | 995
2011-08-12 23:14:52 | 460 | 995
2011-08-12 23:14:53 | 460 | 998
2011-08-12 23:14:54 | 460 | 1001
2011-08-12 23:14:55 | 460 | 999
2011-08-12 23:14:56 | 460 | 996
2011-08-12 23:14:57 | 460 | 997
2011-08-12 23:14:58 | 460 | 1000
2011-08-12 23:14:58 | 460 | 998
2011-08-12 23:14:59 | 460 | 998
2011-08-12 23:15:00 | 460 | 1001
2011-08-12 23:15:01 | 460 | 999
2011-08-12 23:15:02 | 460 | 992
2011-08-12 23:15:03 | 460 | 1000
2011-08-12 23:15:04 | 460 | 998
2011-08-12 23:15:05 | 460 | 995
2011-08-12 23:15:06 | 460 | 993
2011-08-12 23:15:07 | 460 | 1000
2011-08-12 23:15:08 | 460 | 998
2011-08-12 23:15:09 | 460 | 995
2011-08-12 23:29:51 | 460 | 989
2011-08-12 23:29:52 | 460 | 988
2011-08-12 23:29:53 | 460 | 985
2011-08-12 23:29:54 | 460 | 986
2011-08-12 23:29:55 | 460 | 983
2011-08-12 23:29:56 | 460 | 990
2011-08-12 23:29:57 | 460 | 990
2011-08-12 23:29:58 | 460 | 990
2011-08-12 23:29:58 | 460 | 986
2011-08-12 23:29:59 | 460 | 984
2011-08-12 23:30:00 | 460 | 985
2011-08-12 23:30:01 | 460 | 981
2011-08-12 23:30:02 | 460 | 983
2011-08-12 23:30:03 | 460 | 977
2011-08-12 23:30:04 | 460 | 984
2011-08-12 23:30:05 | 460 | 984
2011-08-12 23:30:06 | 460 | 984
2011-08-12 23:30:07 | 460 | 985
2011-08-12 23:30:08 | 460 | 989
2011-08-12 23:30:09 | 460 | 978
2011-08-12 23:44:51 | 460 | 982
2011-08-12 23:44:52 | 460 | 974
2011-08-12 23:44:53 | 460 | 972
2011-08-12 23:44:54 | 460 | 974
2011-08-12 23:44:55 | 460 | 974
2011-08-12 23:44:56 | 460 | 976
2011-08-12 23:44:57 | 460 | 976
2011-08-12 23:44:58 | 460 | 977
2011-08-12 23:44:58 | 460 | 973
2011-08-12 23:44:59 | 460 | 973
2011-08-12 23:45:00 | 460 | 974
2011-08-12 23:45:01 | 460 | 974
2011-08-12 23:45:02 | 460 | 973
2011-08-12 23:45:03 | 460 | 973
2011-08-12 23:45:04 | 460 | 979
2011-08-12 23:45:05 | 460 | 967
2011-08-12 23:45:06 | 460 | 962
2011-08-12 23:45:07 | 460 | 956
2011-08-12 23:45:08 | 460 | 959
2011-08-12 23:45:09 | 460 | 961
2011-08-12 23:59:51 | 460 | 967
2011-08-12 23:59:52 | 460 | 965
2011-08-12 23:59:53 | 460 | 969
2011-08-12 23:59:54 | 460 | 966
2011-08-12 23:59:55 | 460 | 965
2011-08-12 23:59:56 | 460 | 968
2011-08-12 23:59:57 | 460 | 968
2011-08-12 23:59:58 | 460 | 970
2011-08-12 23:59:58 | 460 | 964
2011-08-12 23:59:59 | 460 | 966
2011-08-13 00:00:00 | 460 | 965
2011-08-13 00:00:01 | 460 | 964
2011-08-13 00:00:02 | 460 | 964
2011-08-13 00:00:03 | 460 | 966
2011-08-13 00:00:04 | 460 | 965
2011-08-13 00:00:05 | 460 | 964
2011-08-13 00:00:06 | 460 | 967
2011-08-13 00:00:07 | 460 | 968
2011-08-13 00:00:08 | 460 | 968
2011-08-13 00:00:09 | 460 | 967
2011-08-13 00:14:51 | 460 | 949
2011-08-13 00:14:52 | 460 | 944
2011-08-13 00:14:53 | 460 | 950
2011-08-13 00:14:54 | 460 | 947
2011-08-13 00:14:55 | 460 | 949
2011-08-13 00:14:56 | 460 | 945
2011-08-13 00:14:57 | 460 | 949
2011-08-13 00:14:58 | 460 | 946
2011-08-13 00:14:58 | 460 | 946
2011-08-13 00:14:59 | 460 | 945
2011-08-13 00:15:00 | 460 | 943
2011-08-13 00:15:01 | 460 | 948
2011-08-13 00:15:02 | 460 | 946
2011-08-13 00:15:03 | 460 | 945
2011-08-13 00:15:04 | 460 | 942
2011-08-13 00:15:05 | 460 | 945
2011-08-13 00:15:06 | 460 | 946
2011-08-13 00:15:07 | 460 | 949
2011-08-13 00:15:08 | 460 | 948
2011-08-13 00:15:09 | 460 | 951
2011-08-13 00:29:51 | 460 | 955
2011-08-13 00:29:52 | 460 | 952
2011-08-13 00:29:53 | 460 | 952
2011-08-13 00:29:54 | 460 | 948
2011-08-13 00:29:55 | 460 | 953
2011-08-13 00:29:56 | 460 | 952
2011-08-13 00:29:57 | 460 | 949
2011-08-13 00:29:58 | 460 | 953
2011-08-13 00:29:58 | 460 | 950
2011-08-13 00:29:59 | 460 | 951
2011-08-13 00:30:00 | 460 | 951
2011-08-13 00:30:01 | 460 | 953
2011-08-13 00:30:02 | 460 | 950
2011-08-13 00:30:03 | 460 | 951
2011-08-13 00:30:04 | 460 | 950
2011-08-13 00:30:05 | 460 | 949
2011-08-13 00:30:06 | 460 | 954
2011-08-13 00:30:07 | 460 | 951
2011-08-13 00:30:08 | 460 | 950
2011-08-13 00:30:09 | 460 | 950
2011-08-13 00:44:51 | 460 | 965
2011-08-13 00:44:52 | 460 | 970
2011-08-13 00:44:53 | 460 | 964
2011-08-13 00:44:54 | 460 | 968
2011-08-13 00:44:55 | 460 | 962
2011-08-13 00:44:56 | 460 | 966
2011-08-13 00:44:57 | 460 | 964
2011-08-13 00:44:58 | 460 | 963
2011-08-13 00:44:58 | 460 | 971
2011-08-13 00:44:59 | 460 | 970
2011-08-13 00:45:00 | 460 | 964
2011-08-13 00:45:01 | 460 | 964
2011-08-13 00:45:02 | 460 | 965
2011-08-13 00:45:03 | 460 | 963
2011-08-13 00:45:04 | 460 | 961
2011-08-13 00:45:05 | 460 | 962
2011-08-13 00:45:06 | 460 | 967
2011-08-13 00:45:07 | 460 | 961
2011-08-13 00:45:08 | 460 | 961
2011-08-13 00:45:09 | 460 | 961
2011-08-13 00:59:51 | 460 | 952
2011-08-13 00:59:52 | 460 | 948
2011-08-13 00:59:53 | 460 | 956
2011-08-13 00:59:54 | 460 | 952
2011-08-13 00:59:55 | 460 | 947
2011-08-13 00:59:56 | 460 | 957
2011-08-13 00:59:57 | 460 | 959
2011-08-13 00:59:58 | 460 | 956
2011-08-13 00:59:58 | 460 | 955
2011-08-13 00:59:59 | 460 | 954
2011-08-13 01:00:00 | 460 | 956
2011-08-13 01:00:01 | 460 | 955
2011-08-13 01:00:02 | 460 | 950
2011-08-13 01:00:03 | 460 | 948
2011-08-13 01:00:04 | 460 | 955
2011-08-13 01:00:05 | 460 | 955
2011-08-13 01:00:06 | 460 | 954
2011-08-13 01:00:07 | 460 | 952
2011-08-13 01:00:08 | 460 | 947
2011-08-13 01:00:09 | 460 | 951