I have a weekly redundant task of submitting my hours worked for the week. I
have a table setup in an email where the 1st column is the date, second
column is start time, third column is stop time, and fourth column is total
hours (for that day). At the bottom of the 4th column is total for the week.
I can easily put in a formula to sum up each of the daily hours for the
week. What I would like to do is set it up so the daily hours in the fourth
column are 'computed' rather than my doing them in my head. There is no
field to put in there except for =formula.

What formula can I use to add (or subtract time)? Do I need to use 24 hour
clock format for time entry or can I stick with am and pm?

Thanks in advance for any help you can provide.

--Jim

Outlook has no ability to perform calculations on multiple items in a view. Export to excel and do the calculations there.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Spike9458" wrote in message ...
I have a weekly redundant task of submitting my hours worked for the week. I
have a table setup in an email where the 1st column is the date, second
column is start time, third column is stop time, and fourth column is total
hours (for that day). At the bottom of the 4th column is total for the week.
I can easily put in a formula to sum up each of the daily hours for the
week. What I would like to do is set it up so the daily hours in the fourth
column are 'computed' rather than my doing them in my head. There is no
field to put in there except for =formula.

What formula can I use to add (or subtract time)? Do I need to use 24 hour
clock format for time entry or can I stick with am and pm?

Thanks in advance for any help you can provide.

--Jim