2018-06-27 08:26:48 +0200 received badge ● Famous Question (source) 2018-05-27 18:06:41 +0200 received badge ● Famous Question (source) 2018-05-27 18:06:41 +0200 received badge ● Notable Question (source) 2018-05-14 09:28:01 +0200 received badge ● Notable Question (source) 2017-10-23 15:34:45 +0200 received badge ● Notable Question (source) 2017-10-04 09:24:05 +0200 received badge ● Famous Question (source) 2017-09-08 12:10:19 +0200 received badge ● Popular Question (source) 2017-09-07 22:41:45 +0200 commented answer How to add a column of Hours I Have tried as suggested both ways [HH]:MM:SS and [UU]:MM:SS but I get a total of -444:15:00, any ideas? 2017-09-07 22:41:23 +0200 commented answer How to add a column of Hours I Have tried as suggested both ways [HH]:MM:SS and [UU]:MM:SS but I get a total of -444:15:00, any ideas? 2017-09-07 19:30:46 +0200 edited question How to add a column of Hours How to add a column of Hours On a sheet I am Calculating the total time from the F column as below; F4=10:30 F5=09:30 F 2017-09-07 19:29:00 +0200 edited question 1 cell = many cells filled 1 cell = many cells filled If cell A1=10 how can I make calc fill cells B1 to B10 in red Or if cell C1=Tom and cell C2= 2017-09-07 19:28:02 +0200 marked best answer Autofill cells with a formula Sequence I have a simple formula in Cell C2; =SUM(A1+15000)-A1  I would like calc to auto fill the formula+1 for the selected cells (C2:C270) like this Cell C3; =SUM(A1+15000)-A2 Cell C4; =SUM(A1+15000)-A3 Cell C5; =SUM(A1+15000)-A4  Is there any way to do this? Thank you 2017-09-07 19:26:26 +0200 marked best answer Check A Cell Date Against Current Date Hi Community. Cell A1 = 01/09/2017  can I Ask Calc To Check the date in Cell A1 against the Current Date? Maybe this would be done via an internet time server? Thank-you for any help and guidance. 2017-09-07 19:25:42 +0200 edited question How to add a column of Hours How to add a column of Hours On a sheet I am Calculating the difference between two times with the results as below; F4 2017-09-07 19:24:57 +0200 edited question How to add a column of Hours How to add a column of Hours On a sheet I am Calculating the difference between two times with the results as below; F4 2017-09-07 19:24:05 +0200 asked a question How to add a column of Hours How to add a column of Hours On a sheet I am Calculating the difference between two times with the results as below; F4 2017-09-06 21:17:27 +0200 received badge ● Notable Question (source) 2017-09-06 15:03:36 +0200 received badge ● Popular Question (source) 2017-09-06 14:58:21 +0200 received badge ● Popular Question (source) 2017-09-06 06:37:25 +0200 received badge ● Popular Question (source) 2017-09-06 00:08:32 +0200 asked a question 1 cell = many cells filled 1 cell = many cells filled If cell A1=10 how can I make calc fill cells B1 to B10 in red Or if cell C1=Tom and cell C2= 2017-09-06 00:00:03 +0200 received badge ● Enthusiast 2017-09-02 12:31:47 +0200 received badge ● Notable Question (source) 2017-09-01 22:19:19 +0200 asked a question Autofill cells with a formula Sequence Autofill cells with a formula Sequence I have a simple formula in Cell C2; =SUM(A1+15000)-A1 I would like calc to aut 2017-08-31 23:30:14 +0200 asked a question Check A Cell Date Against Current Date Check A Cell Date Against Current Date Hi Community. Cell A1 = 01/09/2017 can I Ask Calc To Check the date in Cell A1 2017-08-30 12:57:10 +0200 received badge ● Popular Question (source) 2017-08-29 22:33:09 +0200 edited question Calculate difference between two cells - Part 2 Calculate difference between two cells - Part 2 I'm doing a mileage spreadsheet for my car, In cell A1 heading = Mileag 2017-08-29 22:03:03 +0200 edited question Calculate difference between two cells - Part 2 Calculate difference between two cells - Part 2 I'm doing a mileage spreadsheet for my car, In cell 1A heading = Mileag 2017-08-29 21:06:49 +0200 received badge ● Editor (source) 2017-08-29 21:06:49 +0200 edited question Calculate difference between two cells - Part 2 Calculate difference betwwen two Cells Part 2 Hi community, Librebel gave me this array code(Thanks Again) =OFFSET($A$1 2017-08-29 21:06:11 +0200 edited question Calculate difference between two cells - Part 2 Calculate difference betwwen two Cells Part 2 Hi community, Librebel gave me this array code(Thanks Again) =OFFSET($A$1 2017-08-29 21:05:11 +0200 received badge ● Organizer (source) 2017-08-29 20:37:28 +0200 asked a question Calculate difference between two cells - Part 2 Calculate difference betwwen two Cells Part 2 Hi community, Librebel gave me this array code(Thanks Again) =OFFSET($A$1 2017-08-25 23:12:42 +0200 marked best answer Calculate the difference between two cells In cell 1A value = 100 in cell 2A value = 200 In cell 3A value = 300 ..and so on Difference amount goes into 1B So in this case 1B = 200 (3A-1A)  Without knowing how many entries will be introduced in column A (could be 10 or could be 110 entries) How can I ask calc to calculate the difference between the last entry in Column A and the first Entry in Column A (1A) So Basically I just want to subtract the first entry from the last current entry In Column A with out out knowing how many entries there might be. Thanks for the help 2017-08-25 23:12:42 +0200 received badge ● Scholar (source) 2017-08-25 21:56:15 +0200 commented answer Calculate the difference between two cells That is perfect just what i needed thankyou very much. Just A quick edit. If I wanted to apply the same formula to C col 2017-08-25 08:46:02 +0200 received badge ● Popular Question (source) 2017-08-25 08:46:02 +0200 received badge ● Notable Question (source) 2017-08-24 21:22:33 +0200 asked a question Calculate the difference between two cells Calculate the difference between two cells In cell 1A value = 100 in cell 2A value = 200 In cell 3A value = 300 ..and so