LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 23
Default Running Total for Time Spent for a project in 1 month

I am working on a sheet that is to track meeting times.

I would like to be able to have someone put the date of the meeting, the
start time, end time. Excel will calculate the length. And then there will be
seperate columns for each employee. And there is an option for the user to
type in that the employee is not at the meeting.

I would like to have Excel calulate monthly totals for each employee for
each meeting they were at in that month.

(Example: Bill was at the Jan 5, Jan 12 meetings that were both 60 minutes,
but he was not at the Jan 19 meeting that was also 60. But Jill has been to
all 3)

I would like to have a spot that will say 120 for January meeting minutes
for Bill, and 180 for Jill.

If someone needs me to post a rough outline of my chart I can. I posted this
question before, but having problems moving it from the help I got to my
sheet.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I calculate amount of time left based on amount spent? KLD Excel Worksheet Functions 3 May 23rd 06 04:20 PM
How can I show time spent? L Excel Worksheet Functions 1 May 8th 06 03:13 PM
Missing library when running 98 project on 2003 Mary Omond Excel Discussion (Misc queries) 0 May 2nd 05 01:36 PM
Funcation to average the Time spent subbu Excel Worksheet Functions 1 December 7th 04 09:38 AM
How do I calculate the hours spent on a project by entering a sta. joeh Excel Worksheet Functions 4 November 2nd 04 06:39 PM


All times are GMT +1. The time now is 11:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"