Thanks this worked out well. Ok so here would be my next question then.

I have the end of week total and that cell is formatted as suggested below
[h]:mm, the new problem I am having is that I have a cell for hourly rate
but when I multiply Total Hours Worked by Hourly Rate I am getting a wrong
amount. Example:

Total Hrs 20:30 x $10 Hourly Rate is giving me $8.54

How can I now get the Hourly rate to recognize Total Hours as a number?

Thanks again for the help.

Jeff


"BoniM" wrote in message
...
Enter all values as hour:minutes (it's okay if they will all appear as AM
in
formula bar)
Total daily hours with:
=MOD(B3-A3,0.5)
Time In Time Out Total Hours
8:05 4:30 8:25
Format all cells as custom: h:mm
Total weekly hours with the sum function and format that cell as [h]:mm.
(In a time format, h is for hour, a number between zero and 23. [h] is
for
elaspsed time and allows you to go above 23.)

This formula will only be accurate as long as hours worked are <12.
Good luck!

"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