Hi I am making a call log, I am a manager at a resort and I want to report on my calls after hours.
In ms excel, I have manually entered data for the following fields
Day, date, time, Hr, Call No.
I have attached my spreadsheet with calls for the last 15 days of march now I Need the totals for the month.
I have put Question marks in the fields I need to populate
So, total DAYS to start with. If i have entered a day in the Day field I want to count it and put it in a box in the TOTAL DAYS at the bottom. THe answer should be 17.
Days on are my days on - see comment in red. the rest is straight forward!
This is pretty basic for you guys Im sure. I'm use to Mysql, Im trying to relate the functions but not having much luck.. Could someone fix this for me and send it back, so I can see how the functions work.. Thank VERY much !!