Hi Diane,
I was able to clean up the code and got that working..Thank you so much for your help. It was indeed 10 months effort. Now i want this macro to take into new height and i want your help again. As i said earlier, I am tracking / want to track shared email account where team sits in...
Happy Diwali...Diane..
Wow Wow Wow....i dont have words to express my happiness. Your responses to my help is outstanding. Let me try and come back to you.
Hi Diane, Thank you so much for replying. I did checked in vba editor and it was indeed correct result i got. Now i want this to be populated in new field as and when email is received. Is there any way we can call this macro as and when replied and result be stamped in new field?. I am also...
I am so happy that you are responding to my questions. I wil explore on this but I am actually looking a solution inside outlook as against any other applications interference
Yes Diane, you are right I want to know the # of working hours between the mail arriving and the reply. So you are saying if I add LDate = GetTargetDate(myMail.ReceivedTime, 36) in outlook new field will this populate the desired result?
Hi Diane, Could you have a look at this link, this is exactly i was looking for. If I get this particular thing work and populate the result (or call the macro when email responded and populate the result in the new field) that would be great.
VBA - Outlook 2010 - Using ReceivedTime of email in...
Hi Diane, Hope you are good. I am still working on this (at my leisure time) and found the difference between Last verb executed time and Modified time. While creating new field for Received time, Modified time and Last verb executed time to capture seconds (hh:mm:ss). i see there is a...
Hi Diane,
I have applied alternative to Mod function and it worked great. but i am hitting the wall at beyond 24 hour format :-(
Working Day field - correct answer both in excel and outlook : IIf([Last Verb Exec Type]<>"None",INT((WEEKDAY([Received]-2)+[Last Verb Exec...
Yeah..Yeah...i understand Mod is an equation...Thanks Diane..for taking your time and replying. I am working on it and will let you know once i figure it out :-)
If that is the case, Can I go ahead and directly put this formulae =(SUM(INT((WEEKDAY(A3-{2,3,4,5,6})+B3-A3)/7))-1)*("17:00"-"8:00")+MOD(B3,1)-MOD(A3,1).
Aaaahhhhh......hurray....Finally...I have got to work to go beyond 24 hours....Thanks Diane..Thank you so much. :-)
The Result for the above is 613:54 but ideally it should be 142:54. I am trying to figure out with my workings..and will let you know the result. thanks again.
Hi Diane,
I have tried with both the formulas already but the time hours is not going beyond 24 hours. For Email Received time = 24-03-17 10:45:00 AM and Email Actioned time = 19-04-17 11:39:00 AM and the result should be = 142:54:00 but with your suggested formula is showing as 10:06:08. Does...
Hi Diane,
Thanks for reply. I tried with your suggestion but the result is coming as 00:00. so i broke that formulae into two and created a new field and applied date serial number alone and the result is Tue 30-11-99 12:00 AM for all the emails and later when i applied format the result is...
Ah...finally, after I have broken that lengthy formule into 4 function and applied both in excel and outlook for email received 03-04-17 09:00:00 AM and sent 03-04-2017 12:00:00 PM(by creating 3 custom fields - Weekday, Start time, endtime and SLA (weekday - starttime - endtime)/24) the answer...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.