Jeff

Chip Pearson has a site on Timesheets which explains most of this quite well.

http://www.cpearson.com/excel/overtime.htm

See also at the bottom of page the links to other pages working with dates and
times.


Gord Dibben MS Excel MVP

On Tue, 01 May 2007 18:45:32 GMT, "Jeff" wrote:

Hi,

Wondering if someone can help. I am just trying to make a simple like time
sheet.

Time In Time Out Toatal Hours Worked
8.05 4.30 8.25

i would like this for each day of the week then at the end have a toal hours
for the week worked.

I can not figure out the formating to put in and then be able to get the
right ending total. If i formate the cell as time (h:mm) the i have to type
in 8:05 and then that does not seem to work for pm because when I type 4:30
it thinks it is am, so I guess that you need to know military time?

Is there a simple way to just be able to type 8.05 4.30 and it knows the
first column is AM and the second column is PM and then the toal column is
also in time? When I tried putting it in all as number or text when I got
to the grand total it did not know it was time so went off based on 100 and
not 60 minutes.

I guess I am confused how to make it simple to type in but have it calculate
correctly?

Thanks for the Help.

Jeff