LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default Calculate number needed to maintain an average

C2 through C22 represent the work days in August. In each cell total "Talk
Time" minutes are entered manually. C23 adds these up and returns them as
hours and minutes. C25 adds all the days worked (by counting the cells in C2
through C22 that have data in them). C24 is the "Average Talk Time"
(calculated by dividing C23 by C25).

What I need is a cell that will tell me the next day's "Talk Time" would
have to be to make sure that the "Average Talk Time" in C24 maintains 3 or
more hours.

Thank you!
 
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
calculate number of day to deplete inventory without average xavier Excel Discussion (Misc queries) 1 April 3rd 09 09:43 AM
average line needed from one single cell Norbert[_2_] Charts and Charting in Excel 3 November 20th 08 02:04 PM
Average less MIN formula help needed Caribbrz Excel Discussion (Misc queries) 13 May 9th 07 02:02 AM
Calculate a 30-day moving average based on the last x number of entries and date gimiv Excel Worksheet Functions 14 July 7th 06 12:49 PM
Average Function Help Needed michaelas Excel Worksheet Functions 9 September 13th 05 01:19 AM


All times are GMT +1. The time now is 09:07 PM.

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"