 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / May 2008Function to calculate total hours worked in one week.
I have a spreadsheet that has rows of employees. The header row lists Name, Mon, Tues, etc, through Friday, with TOTAL HOURS WORKED at the end. Each row, under day of week listed the employee's work hours (ex: Under Monday I have 7:36 - they worked 7hrs and 36 minutes). How do I calculate the TOTAL HOURS WORKED for the week? I assume there is a formula, but I can't figure it out for hours:minutes worked per week. Thanks so much for any assistance! =sum(B2:F2) or =B2+C2+D2+E2+F2 Format the result as [h]:mm -- David Biddulph >I have a spreadsheet that has rows of employees. The header row lists >Name, [quoted text clipped - 7 lines] > it out for hours:minutes worked per week. Thanks so much for any > assistance! That's what I've done, but the total doesn't compute... This is what I get: 7:54 6:39 7:02 8:09 7:23 TOTAL 181:07 when it should be totalling something over 43 hours and *** minutes... I'm obviously missing something... :( > =sum(B2:F2) or =B2+C2+D2+E2+F2 > Format the result as [h]:mm [quoted text clipped - 12 lines] > > it out for hours:minutes worked per week. Thanks so much for any > > assistance! I get 37:07 when I add those values. My bet is that your values aren't what you see in the cell. You're only seeing the pretty formatted text--not the real value. If you select each cell and look at the formula bar, what values do you see there. > That's what I've done, but the total doesn't compute... This is what I get: > [quoted text clipped - 20 lines] > > > it out for hours:minutes worked per week. Thanks so much for any > > > assistance!  SignatureDave Peterson WOO HOO!! That was it!!! I had one cell that for some reason included a date with the time... THANK U!! THANK U!!! THANK U!!! > I get 37:07 when I add those values. > [quoted text clipped - 28 lines] > > > > it out for hours:minutes worked per week. Thanks so much for any > > > > assistance! UPDATE: I've tried using the [h]:mm & the [hh]:mm formats for the TOTAL HOURS WORKED cell, but it doesn't compute: 7:54 + 6:39 + 7:02 + 8:09 + 7:23 + 7:50 is equalling 188:57?? What am I doing wrong?? ARGH!!! > I have a spreadsheet that has rows of employees. The header row lists Name, > Mon, Tues, etc, through Friday, with TOTAL HOURS WORKED at the end. Each > row, under day of week listed the employee's work hours (ex: Under Monday I > have 7:36 - they worked 7hrs and 36 minutes). How do I calculate the TOTAL > HOURS WORKED for the week? I assume there is a formula, but I can't figure > it out for hours:minutes worked per week. Thanks so much for any assistance! Your difference is exactly 6 days, so it looks as if your input cells include dates, though you are displaying only the times. -- David Biddulph > UPDATE: I've tried using the [h]:mm & the [hh]:mm formats for the TOTAL > HOURS WORKED cell, but it doesn't compute: [quoted text clipped - 14 lines] >> it out for hours:minutes worked per week. Thanks so much for any >> assistance! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.