software

Hi
Hope this makes sense.
I am new at this so if anyone can help with a simple formula for me it would
much appreciated.
I need to make up a weekly timesheet that can calculate normal hours and
overtime hours for each day and show in a seperate column.
If work 35 hours a week
A column showing hours worked at regular, meal times deducted, overtime
hours automatically calculated for the day. At end of sheet total colums for
regular hours, overtime hours, minus meals hours automatically calculated.
--
You are neither too young or old to learn.

Hi!

Here's a free downloadable sample file:

j-walk.com/ss/excel/files/timesht.htm

Study the formulas or just use it as a template.

Biff

quot;Dianequot; gt; wrote in message
news
gt; Hi
gt; Hope this makes sense.
gt; I am new at this so if anyone can help with a simple formula for me it
gt; would
gt; much appreciated.
gt; I need to make up a weekly timesheet that can calculate normal hours and
gt; overtime hours for each day and show in a seperate column.
gt; If work 35 hours a week
gt; A column showing hours worked at regular, meal times deducted, overtime
gt; hours automatically calculated for the day. At end of sheet total colums
gt; for
gt; regular hours, overtime hours, minus meals hours automatically calculated.
gt; --
gt; You are neither too young or old to learn.
Thanks Bif
The timesheet download is great however
is there also a way to insert a column that shows the overtime
worked/calculated on a daily basis and not just calculated at the end of the
week please.--
You are neither too young or old to learn.quot;Biffquot; wrote:

gt; Hi!
gt;
gt; Here's a free downloadable sample file:
gt;
gt; j-walk.com/ss/excel/files/timesht.htm
gt;
gt; Study the formulas or just use it as a template.
gt;
gt; Biff
gt;
gt; quot;Dianequot; gt; wrote in message
gt; news
gt; gt; Hi
gt; gt; Hope this makes sense.
gt; gt; I am new at this so if anyone can help with a simple formula for me it
gt; gt; would
gt; gt; much appreciated.
gt; gt; I need to make up a weekly timesheet that can calculate normal hours and
gt; gt; overtime hours for each day and show in a seperate column.
gt; gt; If work 35 hours a week
gt; gt; A column showing hours worked at regular, meal times deducted, overtime
gt; gt; hours automatically calculated for the day. At end of sheet total colums
gt; gt; for
gt; gt; regular hours, overtime hours, minus meals hours automatically calculated.
gt; gt; --
gt; gt; You are neither too young or old to learn.
gt;
gt;
gt;

To get OT assuming that 8 is regular time, with the total hours worked in a
day in B2

=MAX(0,B2-8)

for decimal values, if B2 holds a time value like 8:00, change to

=MAX(0,B2-quot;08:00quot;)

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon

quot;Dianequot; gt; wrote in message
news
gt; Thanks Bif
gt; The timesheet download is great however
gt; is there also a way to insert a column that shows the overtime
gt; worked/calculated on a daily basis and not just calculated at the end of
gt; the
gt; week please.
gt;
gt;
gt; --
gt; You are neither too young or old to learn.
gt;
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; Hi!
gt;gt;
gt;gt; Here's a free downloadable sample file:
gt;gt;
gt;gt; j-walk.com/ss/excel/files/timesht.htm
gt;gt;
gt;gt; Study the formulas or just use it as a template.
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;Dianequot; gt; wrote in message
gt;gt; news
gt;gt; gt; Hi
gt;gt; gt; Hope this makes sense.
gt;gt; gt; I am new at this so if anyone can help with a simple formula for me it
gt;gt; gt; would
gt;gt; gt; much appreciated.
gt;gt; gt; I need to make up a weekly timesheet that can calculate normal hours
gt;gt; gt; and
gt;gt; gt; overtime hours for each day and show in a seperate column.
gt;gt; gt; If work 35 hours a week
gt;gt; gt; A column showing hours worked at regular, meal times deducted, overtime
gt;gt; gt; hours automatically calculated for the day. At end of sheet total
gt;gt; gt; colums
gt;gt; gt; for
gt;gt; gt; regular hours, overtime hours, minus meals hours automatically
gt;gt; gt; calculated.
gt;gt; gt; --
gt;gt; gt; You are neither too young or old to learn.
gt;gt;
gt;gt;
gt;gt;