If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do I create a formula to add up time on a time sheet
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. |
#2
|
|||
|
|||
how do I create a formula to add up time on a time sheet
JR Crawdad wrote:
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 he http://www.cpearson.com/excel/overtime.htm |
#3
|
|||
|
|||
how do I create a formula to add up time on a time sheet
See Chip Pearson's site for Timesheet calculations, including OT and lunch
breaks. http://www.cpearson.com/excel/overtime.htm And for more help doing Time calcualtions see this site of Chip's http://www.cpearson.com/excel/datetime.htm#AddingTimes Gord Dibben MS Excel MVP On Wed, 17 Feb 2010 13:37:01 -0800, JR Crawdad JR wrote: 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. |
#4
|
|||
|
|||
how do I create a formula to add up time on a time sheet
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 "JR Crawdad" JR wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|