I'm in the middle of a custody battle with my ex and need expert help.
I have an Excel spreadsheet with every phone call to and from my son. The calls can be from the ex to my son while he's with me, from me to my son when he's with my ex, returning missed calls, etc. Each call is logged with the date, time and duration of call.
im looking for help in order to break down the calls via built-in tools. I'd like to create several charts:
- number of calls to, from, returning, etc.
- number of calls per week (say sun-sat) for every week since a certain date
- number of calls on Mondays, Tuesday's, Wednesday's, etc.
- perhaps others.
Any any suggestions on how to accomplish these charts? I have an intermediate knowledge of excel and have excel 2013
I have an Excel spreadsheet with every phone call to and from my son. The calls can be from the ex to my son while he's with me, from me to my son when he's with my ex, returning missed calls, etc. Each call is logged with the date, time and duration of call.
im looking for help in order to break down the calls via built-in tools. I'd like to create several charts:
- number of calls to, from, returning, etc.
- number of calls per week (say sun-sat) for every week since a certain date
- number of calls on Mondays, Tuesday's, Wednesday's, etc.
- perhaps others.
Any any suggestions on how to accomplish these charts? I have an intermediate knowledge of excel and have excel 2013