View Single Post
  #1  
Old March 4th 06, 01:09 AM posted to microsoft.public.outlook.program_vba
Qiubang Li
external usenet poster
 
Posts: 1
Default Sum up overtime hours for my sent mails over one year

Hi Everyone,

I have some experience in vba programming but a newbie in outlook
programming. Can anyone help me to write a code in outlook to calculate how
many hours I have worked for my boss for the past one year. My working hours
are 9:00AM - 5:00PM. Everyday I sent an daily progress update to my boss.
Sometimes it's at 5:30PM or 6:00PM. It means I have worked half an hour or 1
hour overtime at that particular day. The whole idea is to go to the sent
folder, check all those mails sent to my boss, and sum up all those hours
with mails sent after 5:00PM. Can anyone give me some idea how to do it?
Many thanks.

--
Q Li


Ads