Autosum

[Snowmonster]

Hi...
Can someone, please, help me solve this probably very simple issue...
I have attached a screenshot...

I4→I10 have the same formula, but with descending cell values, I have then copied the same formula into I11→I17... When I try to autosum the second set of figures (11→I17) it just comes up with a blank, but the above autosum works, and it has the same formula... Then only thing I can think it could be is the statement to add "08:00", which means it's text, right? So how can I get around this issue?

Thanks for your time

Snowmonster

[6StringJazzer]

I will give this a try based on what you provided but see suggestion below. Replace "08:00" with TIME(8,0,0).

An image attachment has very little value. Just attach the Excel file. It's easier than taking a screenshot first and then attaching that.

It will be much easier to understand your problem if you provide your file. This allows us to see and experiment with your data, layout, formulas, code, and possibly attach a file with a completed solution. If you are looking for formulas to produce a desired result, it helps if you create a mock-up of what you want the result to look like. Otherwise we would have to build something from scratch, trying to guess what you want it to look like.

The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

[FDibbins]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )