I'd like to make a FOOD schedule spread sheet

[guiri]

Guys, I am trying to make a spread sheet that keeps track of what I eat, when I do it and the average time between meals.

I tried Excel since I'm assuming it's doable but of course, to do it, one must be able to explain it to others when one's asking for help.

The actual span of a day is really irrelevant to me because I have insomnia and my days can last 40 hours and it could be from 9 am to 9pm or whatever.
I would like one row to be one of my days. Ie, when I start entering info to when I stop entering is ONE day/one day between sleep that is.

THen I'd like to see how long time between meals for THAT row.

I then do this down the page till I'm done with how many days there are in a month.

At the bottom, it should take all the AVERAGE hours from each row and give me the average of the whole month.

Is that possible and I would be more than happy to upload my spread sheet for you to play around with so you don't have to make a new one. Here, I just uploaded it for you guys to play with if THIS is doable.

I don't see how to make a link but here it is below., If you try to explain, do it is if I were an idiot because that's where I am with written explanations. I would also be up for calling someone to explain it to me/talk me through it
as that works better for me.

extuff.biz/Food-Schedule.xlsx

QUestions, please ask.

Thanks, George

 

[sooshil]

Use this formula to cell AH3

=AVERAGE(F3-B3,J3-F3,N3-J3,R3-N3,V3-R3,Z3-V3,AD3-Z3)

It gives your average hours and minutes of that day in time format.
Take average of the column at the end of the month.

If you want to keep it in AH34, then formula in AH34 will be

=AVERAGE(AH3:AH33)

 

[guiri]

Use this formula to cell AH3

=AVERAGE(F3-B3,J3-F3,N3-J3,R3-N3,V3-R3,Z3-V3,AD3-Z3)

It gives your average hours and minutes of that day in time format.
Take average of the column at the end of the month.

If you want to keep it in AH34, then formula in AH34 will be

=AVERAGE(AH3:AH33)

Yeah, I'm beyond dense so could you perhaps put this in the spreadsheet for me and then let me
have it to look at? I"ll understand better how to do it then.

Also, do I need to enter just hours or date and hours in the fields and if so, is there a way
to automatically enter that?> I know there is but **** if I can figure out how to do it.

Thanks

George

 

[sooshil]

Here is the link of your file.
https://drive.google.com/file/d/1Uz9jQJebuIOjfRzB8ug2iKbJwlhfL-W9/view?usp=sharing

Make sure you enter your time to every column you have created to get the better result.

 

[guiri]

Thanks. I could not test it online since I couldn't figure out how so I downloaded it but when I try to use it, the rows are overlapping each other so I can't see what it says.

ALso, since a day for me is very often more than 24 hours, do I not need to also enter a date so that the sheet knows that I'm on a NEW day once I go past the same hour again? Ie, 4 am then back around to 4-5 am?

Here's a screen capture of what i see.

extuff.biz/FoodSheet-overlapping.jpg

Thanks

 

[guiri]

ALso, how do I post links? I don't see an option for that.

 

[sooshil]

Text being partly hidden is just the problem of some formatting on cell alignment.
Here is the link for the file.
https://drive.google.com/file/d/1LqSHPBksPEcVGWRaNMGVgIVxZuS0FjRC/view?usp=sharing

If your time goes beyond 12:00 midnight, you need to enter that time to the next day in next row.

 

[guiri]

Sorry to be a pain but I can't get it to work. The first one I tried just shows #NUM ! and the little triangle and the next row I try, it diesn't add anything up at all

 

[sooshil]

Here is the solution.
Please make sure, if your time goes beyond midnight, you enter that time into the next day.


https://drive.google.com/file/d/1xnaGmjSW_dzqw1GUm8vFMuLnf5Q4WKdA/view?usp=sharing

hope this helps.

 

[guiri]

So, no matter what time I start with, it cannot go past midnight 11:59pm on the same row, right?
So, 12 am is after midnight then?

Because I WOULD like one row to be one of my messed up long days. Is it possible to do DATE and time and would Excel distinguish between that?

Thanks again