Adding hours in Excel

M

MJ

Hello
I am trying to create a timesheet which tracks the total hours worked in a
day along with overtime. I don't want to show the lunch break but I want to
factor it in.
ex.
Start 7 AM
End 6 PM
Total Hours 10 Hours (1hr for lunch)

I also want to be able to track the hours per week based on a 50 hr work week.

Any suggestions would be appreciated.

Thanks in advance
 
T

Tyro

Time in Excel is expressed as a fractional number of 24 hours. Over 24 hours
has an integer portion. Simply add, subtract. Perhaps a good book on Excel
would help you.

Tyro
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top