I3 is not being ignored. If you didn't count I3, your total would be 11.
If you format your total cell as general it shows 11.0125.
0.0125 is the value in I3. Perhaps you had forgotten that I3 is a time
being displayed in an [m] format? If you want to include the number of
minutes from I3 in your total, then change your =SUM(E3+I3+K3+M3+O3) to
=E3+I3*24*60+K3+M3+O3
The other option is to remove the division by 1440 from your formula in I3,
and then I3 will be a number in minutes, not a time. You seem to be making
life complicated for yourself by multiplying by 1440 on H3 and then dividing
again in I3. H3 is in minutes, but I3 is back to being a time. If you are
working in a mixture of times and numbers of minutes, you need to remember
which of your cells is which.
--
David Biddulph

"nlp239" wrote in message
...
Thanks ever so much for not giving-up on me.
The file is located at http://www.savefile.com/files/1875657 and has a
line of real data.


On Nov 7, 9:33 am, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
If you are still struggling to sort out your problem, you can upload to
somewhere likehttp://www.savefile.com/and let us know the url of your
file.
--
David Biddulph

"nlp239" wrote in message

...



...
I'm sure you guys don't like to retype things so, is there a way I can
show you the spreadsheet. Should I upload it and link to it?
Thanks again.- Hide quoted text -

- Show quoted text -