+ Reply to Thread
Results 1 to 2 of 2

Calculations using Time

Hybrid View

  1. #1
    Registered User
    Join Date
    11-17-2009
    Location
    Exeter,England
    MS-Off Ver
    Excel 2007
    Posts
    6

    Calculations using Time

    Hi

    I am trying to find out how to do some basic calculations using time ( i.e. hh:mm:ss).
    I have a sheet which shows the number of hours spent on a task each day which I need to add up to get a total for a month in hh:mm:ss format. I have found you can do this by setting the format of the cell where you add up the totals to [h]:mm:ss format. This works quite happily and gives you a total hours worked on that task for the month.

    What I now want to do though is display this as a % of the total hours in the month spent on all tasks. So say you worked X days this month and you know each day was 9 hours long. X is a variable number say in Cell A1. You would have a formula to work out the total worked hours (9*A1) . However I can't quite find a way to calcualte this correctly in [h]:mm:ss equivalent format. I need to then divide the total hours worked on my task by this figure and display as a %. i.e what % of the total hours worked this month were spent on this task.

    I am really struggling to work out a formula that can calculate the total hours for X days in the equivalent of [h]:mm:ss format and produce a correct result as a percentage.

    Any bright sparks out there know how to do this?

    Many Thanks

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Calculations using Time

    Either use:

    "9:00"*A1

    as the divisor or conversely convert the Time to decimal hours (ie * aggregate by 24 prior to division)

    I would suggest you use the first approach.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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