Venkata Murugan Guna
Member
- Outlook version
- Outlook 2010 64 bit
- Email Account
- IMAP
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 Time]-[Received])/7)+INT((WEEKDAY([Received]-3)+[Last Verb Exec Time]-[Received])/7)+INT((WEEKDAY([Received]-4)+[Last Verb Exec Time]-[Received])/7)+INT((WEEKDAY([Received]-5)+[Last Verb Exec Time]-[Received])/7)+INT((WEEKDAY([Received]-2)+[Last Verb Exec Time]-[Received])/6))*(TimeSerial(18,0,0)-TimeSerial(9,0,0))
Mod for end time Field - correct answer both in excel and outlook : IIf([Last Verb Exec Type]<>"None",CDbl([Last Verb Exec Time])-(Int(CDbl([Last Verb Exec Time])/1)*1))
Mod for received time field - correct answer both in excel and outlook : CDbl([Received])-(Int(CDbl([Received])/1)*1)
Final Field = Working day field + End time file - Start time field = 6.329074. This is also corrrect in excel and outlook.
But failed to get hours beyond 24 hours. :-(. Please help. I scratched my head for almost 3 days.
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 Time]-[Received])/7)+INT((WEEKDAY([Received]-3)+[Last Verb Exec Time]-[Received])/7)+INT((WEEKDAY([Received]-4)+[Last Verb Exec Time]-[Received])/7)+INT((WEEKDAY([Received]-5)+[Last Verb Exec Time]-[Received])/7)+INT((WEEKDAY([Received]-2)+[Last Verb Exec Time]-[Received])/6))*(TimeSerial(18,0,0)-TimeSerial(9,0,0))
Mod for end time Field - correct answer both in excel and outlook : IIf([Last Verb Exec Type]<>"None",CDbl([Last Verb Exec Time])-(Int(CDbl([Last Verb Exec Time])/1)*1))
Mod for received time field - correct answer both in excel and outlook : CDbl([Received])-(Int(CDbl([Received])/1)*1)
Final Field = Working day field + End time file - Start time field = 6.329074. This is also corrrect in excel and outlook.
But failed to get hours beyond 24 hours. :-(. Please help. I scratched my head for almost 3 days.