Search results

  1. Venkata Murugan Guna

    How to sum hours, minutes, or seconds in Outlook

    Oh ok..not a problem I will do it on my own :-). thanks for helping hand..will keep you posted about the progress
  2. Venkata Murugan Guna

    How to sum hours, minutes, or seconds in Outlook

    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...
  3. Venkata Murugan Guna

    How to sum hours, minutes, or seconds in Outlook

    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.
  4. Venkata Murugan Guna

    How to sum hours, minutes, or seconds in Outlook

    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...
  5. Venkata Murugan Guna

    How to sum hours, minutes, or seconds in Outlook

    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
  6. Venkata Murugan Guna

    How to sum hours, minutes, or seconds in Outlook

    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?
  7. Venkata Murugan Guna

    How to sum hours, minutes, or seconds in Outlook

    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...
  8. Venkata Murugan Guna

    How to sum hours, minutes, or seconds in Outlook

    Oh ok. But why is that last verb not capturing seconds? For all the emails it is showing as "00" in seconds
  9. Venkata Murugan Guna

    How to sum hours, minutes, or seconds in Outlook

    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...
  10. Venkata Murugan Guna

    How to sum hours, minutes, or seconds in Outlook

    Yeah you are right. I will have to work on this this week end with out any distraction
  11. Venkata Murugan Guna

    How to sum hours, minutes, or seconds in Outlook

    This is going beyond my skills o_O. Let me try mean while if you could also lend me your hand that would be of great help
  12. Venkata Murugan Guna

    How to sum hours, minutes, or seconds in Outlook

    Hi Diane, Datediff gives the result including weekends but I am looking at working days
  13. Venkata Murugan Guna

    How to sum hours, minutes, or seconds in Outlook

    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...
  14. Venkata Murugan Guna

    How to sum hours, minutes, or seconds in Outlook

    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 :-)
  15. Venkata Murugan Guna

    How to sum hours, minutes, or seconds in Outlook

    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).
  16. Venkata Murugan Guna

    How to sum hours, minutes, or seconds in Outlook

    Surprised how come Mod function worked when there is no function available in the outlook.
  17. Venkata Murugan Guna

    How to sum hours, minutes, or seconds in Outlook

    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.
  18. Venkata Murugan Guna

    How to sum hours, minutes, or seconds in Outlook

    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...
  19. Venkata Murugan Guna

    How to sum hours, minutes, or seconds in Outlook

    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...
  20. Venkata Murugan Guna

    How to sum hours, minutes, or seconds in Outlook

    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...
Back
Top