how do I create a formula to add up time on a time sheet

J

JR Crawdad

I am creating a weekly time card for our office. I have columns for start
and stop times and have successfully found the formula to get each time
segment to add up in the third column. When I try to make that 3rd column
add up the total hours for the week I can't get a sensible result.
Also, is there a simple way to have my time results automatically subtract
1/2 hour (for lunch) or do I need to split the day into morning and afternoon
as I have so far?
Any help will be appreciated.
 
G

Glenn

JR said:
I am creating a weekly time card for our office. I have columns for start
and stop times and have successfully found the formula to get each time
segment to add up in the third column. When I try to make that 3rd column
add up the total hours for the week I can't get a sensible result.
Also, is there a simple way to have my time results automatically subtract
1/2 hour (for lunch) or do I need to split the day into morning and afternoon
as I have so far?
Any help will be appreciated.


Some help here:

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

Fred Smith

The best way to get help is to tell us how your data is laid out, and what
formulas you are using, what results you are getting, and what you want
instead. Without that, we're just guessing.

Assuming you have start time in column A, and stop time in column B, the
your work time would be:
=b1-a1
formatted as a time.
If you want to subtract 1/2 hour for lunch, do it here, as in:
=b1-a1-time(0,30,0)

To get your weekly total, presumably you're summing times, like:
=sum(c1:c7)

The format you want for this is likely: [hh]:mm
The square brackets stop Excel from rolling over after 24 hours.

Regards,
Fred
 

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