# I'd like to make a FOOD schedule spread sheet

#### guiri

##### New Member
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

Thanks, George

### Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

#### sooshil

##### Board Regular
Use this formula to cell AH3
Code:
``=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
Code:
``=AVERAGE(AH3:AH33)``

#### guiri

##### New Member
Use this formula to cell AH3
Code:
``=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
Code:
``=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

#### guiri

##### New Member
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

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

#### guiri

##### New Member
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

#### guiri

##### New Member
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