Hi,
I'm new to the forum and excel as well. I was wondering if someone could help me out. I need to count the time elapsed between the date and time a message was left and the date and time the call was returned. I'd also like to know how to display the number of times a call was returned within 24hrs, 48hrs, and +72hrs.
Hi, welcome to the forum
1st, your dates/times are actually text, not real dates/times, but this will still work...
E2=D2-C2
formatted Custom d "days" hh "hours" mm "Minutes" ss "Seconds"
Not really sure what you want inthe other 3 columns, perhaps some samples?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Originally Posted by FDibbins
Hi, welcome to the forum
1st, your dates/times are actually text, not real dates/times, but this will still work...
E2=D2-C2
formatted Custom d "days" hh "hours" mm "Minutes" ss "Seconds"
Not really sure what you want inthe other 3 columns, perhaps some samples?
Thanks for the reply. I've gotten this far in my attached document. What I'm still missing is calls returned in +3days and total calls per week.
For calls at +3 days
=SUMPRODUCT(--((B602:B617-A602:A617)>=4))
How is your week broken up? Mon-Friday? Are we talking about the original Voicemail or the modified date?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks