Results 1 to 7 of 7

How do I take a percentage of total time over a 7 day period when time exceeds 24:00 hrs?

Threaded View

seanpod How do I take a percentage of... 06-30-2015, 11:35 AM
6StringJazzer Re: How do I take a... 06-30-2015, 12:39 PM
seanpod Re: How do I take a... 06-30-2015, 01:28 PM
Jonmo1 Re: How do I take a... 06-30-2015, 02:55 PM
seanpod Re: How do I take a... 06-30-2015, 08:07 PM
ChemistB Re: How do I take a... 06-30-2015, 02:16 PM
6StringJazzer Re: How do I take a... 06-30-2015, 09:11 PM
  1. #1
    Registered User
    Join Date
    06-11-2015
    Location
    NE US
    MS-Off Ver
    2013
    Posts
    70

    How do I take a percentage of total time over a 7 day period when time exceeds 24:00 hrs?

    I have attached a screenshot of what I am working with and attempting to accomplish.

    For 'Tank Usage over 7 Days' I have calculated average time & average minutes wherein average time is by function =AVERAGE(A1, B1, etc.) in the format [hh]:mm and average minutes is by function =(A1)*24*60 in the format General.

    Then I took totals for all tanks using the corresponding cells, but what is the formula to turn this data into percentages by average % of each tank, and by total % of each tank over a 7 day period when time exceeds 24 hours?

    Thanks.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula Needed - Calculate total hours that fall between a specific time period.
    By JennyGP in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 04-19-2020, 02:44 AM
  2. Payroll time sheet calculation where time exceeds 24 hours
    By Rolo1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-23-2014, 08:57 AM
  3. Charting Total Percentage Change over short time period
    By oct in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-12-2013, 12:09 PM
  4. From an AM time to an AM time, exceeds 24 hours. How to calculate?
    By bodycode in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-26-2013, 03:56 AM
  5. Calculate percentage of time period
    By Ricardo Monteiro :^) in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-06-2006, 10:50 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1