 |
 | 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 / General Excel Questions / January 2005CALCULATE HOURS WORKED
I am fairly new to Excel, but I need the formula to calculate hours worked, to include 30-60 min off for lunch. Formula must include hours and minutes worked. You can do math on dates and times exactly as you would with numbers. a b c d 09:00 12:00 13:00 17:00 =(b1-a1)+(d1-c1) > I am fairly new to Excel, but I need the formula to calculate hours worked, > to include 30-60 min off for lunch. Formula must include hours and minutes > worked. ...oh then you can format the answer to hh:mm > I am fairly new to Excel, but I need the formula to calculate hours worked, > to include 30-60 min off for lunch. Formula must include hours and minutes > worked. To add to what Jimbola wrote- If you are totaling up time for a week or longer, you should use a Number Format such as: [h]:mm This will allow the hours total to go passed 2. tj > I am fairly new to Excel, but I need the formula to calculate hours worked, > to include 30-60 min off for lunch. Formula must include hours and minutes > worked. |
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
|
©2012 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.