I'd like to make a FOOD schedule spread sheet

guiri

New Member
Joined
Mar 3, 2007
Messages
16
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
 

Some videos you may like

Excel Facts

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

sooshil

Board Regular
Joined
Feb 21, 2013
Messages
87
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
Joined
Mar 3, 2007
Messages
16
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
Joined
Mar 3, 2007
Messages
16
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
Joined
Mar 3, 2007
Messages
16
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
Joined
Mar 3, 2007
Messages
16
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
 

Watch MrExcel Video

Forum statistics

Threads
1,090,320
Messages
5,413,783
Members
403,501
Latest member
aaa33

This Week's Hot Topics

Top