Sum of columns to right - update when new column inserted

[miro2021]

Hi
I'm trying to create a spreadsheet tracking time total time spent on a list of projects.

Please see below and attached sample.

Each day I want to insert a new column to the right of the Total column (please note that I don't want to add the column after the last column) and enter the time spent in minutes.

P.No. Total 18Oct 17Oct 16Oct
001 30 10 10 10
002 25 15 10 0

..So I'm trying to work out formula to insert in the total column that will add all columns to the right (even when the number of columns increases)

..Ideally the formula would also convert the number of minutes into hours and minutes eg 05:20 for '5 hours 20 minutes' ie. 320minutes

Thanks for any assistance

[bebo021999]

1/ Try to insert a blank column (C) next to Total (B), then merge B&C column. In B2: = sum(C2:F2)
Then next day, insert new column before D and the formula will be alway cover from C column.
2/ To convert:
=SUM(D2:F2)/24/60
formatted as hh:mm

[miro2021]

Thanks for the fast help! - this works perfectly in my sample and I look forward to using it in work tomorrow.

I wish I understood how inserting blank column, merging etc works though!

Kind regards,
Karen

[MarvinP]

Hi Karen,

Instead of using
Sum(C2:E2)
why not use a large column letter that you will never reach like "AA". So your new formula would be:
Sum(C2:AA2)
and then pull it down.

[miro2021]

Actually while implementing this I've just realised I want to calculate working days!!! (working day being 8 hours)

Ie. If the number of minutes added up comes to 2160 ( which comes out as 01:12:00 using bebo021999's formula "=SUM(D2:F2)/24/60" formatted as hh:mm )
...2160 mins is 36 hours I would like this to show as 4 days & 4 hours & 0 mins ... something like 04:04:00

Any help would be appreciated!

Karen

[Pepe Le Mokko]

My post is wrong post - Please disregard