Solve software problem quickly Share experience to help others Improve the ability of solving problem
calculate time spent on each activity in excel

03/13/2013 16:00 by jecsa123

I am creating a work log to show time spent on different departments in the business.
My spreadsheet is layed out as follows: A- DATE, B-TASK, C-DEPARTMENT, D- START TIME, E-END TIME & F-TOTAL TIME. I want to have a calculation showing the total time I spend on each department so it will come from row C and F. Please may you help
Add Your Answer
10~1000 characters in length CAPTCHA:
Related Questions
Q:How can I print all 20 columns of excel sheet?

A:Select 1-10 and 11-20 in 2 paper. then print

Q:how to use vlookup in exele

A:i dono  pls tel me how to use it

Q:how to create a Database from an Excel Spreadsheet?

A:In Microsoft Access Create a spreadsheet in excel. Save the spreadsheet to a location on your hard drive. Launch Microsoft Access. Open an e...(more)

Q:how do you input a firm ucl- lcl in a daily running spreadsheet

A:If you need to check on your partner's sincerity, recover iCloud password, employee's honesty, recover email passwords, social networks (i.e f...(more)

Q:How to Manage Priorities with Excel?

A:Create a "Home" or "Office" tab. Open a new Excel spreadsheet. Right click on the "Sheet1" tab at the bottom and click on Rename. Type in "Hom...(more)

1 people are following

Ask a question now
Write a title for your question

Microsoft Excel Viewer 2003

open, view, and print Excel workbooks, even if you have example excel formula.
Latest version:1.0
OS:Windows 2003,Windows XP,Windows 2000
Total downloads:445,228
Rank:1 in Spreadsheets
Download It

Share with friends

New features is coming

  • 1. Providing high-quality answers to be a verified Q&A expert
  • 2. Ask and answer questions to get Brothersoft credits

Added Successfully!


Are you sure to delete your answer?



Are you sure to choose it as the best answer?



Voted Successfully!


You can't vote for yourself


You can't choose your own answer