Ask Your Question

simontfs's profile - activity

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