0
votes
0answers
15 views

How to get the average time of two cells hh:mm in Google Spreadsheet [migrated]

In columns K and L I have time stamps. Let's say 03:30 is in column K and 04:30 is in column L. I want the total or average amount of time in hh:mm in column P. I have tried the average function, but ...
0
votes
2answers
358 views

Spreadsheets: How do I perform functions on a set/array described by a row of (count, value) pairs?

I have excel 2000, google docs, and the latest open office calc available to me. I'm after a solution in any of those, ideally. I have a multiset of data described by rows of (count, value) pairs. ...
1
vote
1answer
138 views

Alternative, more efficient scraping method for a noncoder, than Google doc's importxml and xpath?

I've searched throughout the net for a simple solution, but it seems everyone has their own unique method (coding language) of achieving this. I'm only just beginning to learn Linux, and my coding ...