G
Gil Grissom
Each day, I track my work time in Outlook by creating two
"appointments": one for the first part of the day and another for the
second part of the day. (Occasionally, I will have subsequent periods
of work as well, i.e. if I go home, have dinner, and work from home.)
In this way, I exclude the time I take for lunch, etc.
I created a user-defined field called "Hours" which uses the following
formula:
Format([Duration]/60,"#0.00")
This returns the number of hours rounded to two decimal places that I
worked for each period.
I defined a tabular view called "Work Hours" which includes these
fields:
Icon
Attachment
Subject
Location
Start
End
Hours
At the end of each week, I select all the work periods for that week,
copy them with Ctrl+C, and paste them into an Excel spreadsheet. Here,
I add the hours for each day and do a grand total for the week.
This method was working fantastic until four weeks ago. Prior to that,
I was using Office XP. Four weeks ago, I upgraded to Office 2003.
Now, in Outlook, I still see the dates as:
ddd mm/dd/yyyy HH:mm
However, now when I copy and paste the dates into Excel, I am seeing
the following behavior:
-The dates going back beyond two weeks simply show mm/dd/yyyy If I try
to change the format in Excel to ddd mm/dd/yyyy HH:mm, the time is
shown as 00:00
-The dates from the previous week are shown as DDD mm/dd If I try to
change the format in Excel to ddd mm/dd/yyyy HH:mm, there is no change.
It is still shown as DDD mm/dd
-The dates from the current week are shown as DDD HH:mm If I try to
change the format in Excel to ddd mm/dd/yyyy HH:mm, there is no change.
It is still shown as DDD HH:mm
NOTE: My calculated field is pasted correctly, reflecting the hours
worked. However, since I am using this as a sort of timecard, I need
to see the days and periods worked each day.
I have been testing this each week for the last four weeks and the
pattern of behavior is the same: the current week is represented one
way; the previous week, another; and beyond that, still another way.
Why would this be happening?
"appointments": one for the first part of the day and another for the
second part of the day. (Occasionally, I will have subsequent periods
of work as well, i.e. if I go home, have dinner, and work from home.)
In this way, I exclude the time I take for lunch, etc.
I created a user-defined field called "Hours" which uses the following
formula:
Format([Duration]/60,"#0.00")
This returns the number of hours rounded to two decimal places that I
worked for each period.
I defined a tabular view called "Work Hours" which includes these
fields:
Icon
Attachment
Subject
Location
Start
End
Hours
At the end of each week, I select all the work periods for that week,
copy them with Ctrl+C, and paste them into an Excel spreadsheet. Here,
I add the hours for each day and do a grand total for the week.
This method was working fantastic until four weeks ago. Prior to that,
I was using Office XP. Four weeks ago, I upgraded to Office 2003.
Now, in Outlook, I still see the dates as:
ddd mm/dd/yyyy HH:mm
However, now when I copy and paste the dates into Excel, I am seeing
the following behavior:
-The dates going back beyond two weeks simply show mm/dd/yyyy If I try
to change the format in Excel to ddd mm/dd/yyyy HH:mm, the time is
shown as 00:00
-The dates from the previous week are shown as DDD mm/dd If I try to
change the format in Excel to ddd mm/dd/yyyy HH:mm, there is no change.
It is still shown as DDD mm/dd
-The dates from the current week are shown as DDD HH:mm If I try to
change the format in Excel to ddd mm/dd/yyyy HH:mm, there is no change.
It is still shown as DDD HH:mm
NOTE: My calculated field is pasted correctly, reflecting the hours
worked. However, since I am using this as a sort of timecard, I need
to see the days and periods worked each day.
I have been testing this each week for the last four weeks and the
pattern of behavior is the same: the current week is represented one
way; the previous week, another; and beyond that, still another way.
Why would this be happening?