+ Reply to Thread
Results 1 to 3 of 3

Excel formula to calculate percentage for hours worked

  1. #1
    Registered User
    Join Date
    11-27-2008
    Location
    Cleethorpes
    Posts
    1

    Excel formula to calculate percentage for hours worked

    Hi

    I am currenlt working on a speadsheet for clocked hours (in & out)

    I have managed to work out the formula to calculate the total hours worked, now what i need to do is calculate the percentage of hours spend on site but for some reason the formula isnt working.

    Please see example below:

    Total hours on site 08.10hrs
    Contracted Hours 10
    % = ??

    the formual i used for this was total hours on site/contracted hours*1 =

    This formula should give me an answer of 81% but for soem reason its giving me and answer of 3.4%. can anyone shed any light on this? is my cell format wrong?

    In Out In Out In Out Total allocated %
    7:50 AM 10:00 AM 10:32 AM 1:30 PM 2:24 PM 5:26 PM 08.10 10 3.4

    This is a copy of the information i am trying to work with...please help!!!

    Thanks

    Kate

  2. #2
    Valued Forum Contributor rwgrietveld's Avatar
    Join Date
    09-02-2008
    Location
    Netherlands
    MS-Off Ver
    XL 2007 / XL 2010
    Posts
    1,671

    re: Excel formula to calculate percentage for hours worked

    It's a formatting thing.

    If you have time 08:10:00 and press the , (comma) to make it a numerical value you'll see that it is 0.34. This is clear as 08:10:00 / 24:00:00 = 0.34. it shows you the fraction of the complete day which is 24 hours.
    Attached Files Attached Files
    Last edited by rwgrietveld; 11-27-2008 at 11:53 AM.
    Looking for great solutions but hate waiting?
    Seach this Forum through Google

    www.Google.com
    (e.g. +multiple +IF site:excelforum.com/excel-general/ )

    www.Google.com
    (e.g. +fill +combobox site:excelforum.com/excel-programming/ )

    Ave,
    Ricardo

  3. #3
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650
    Hi, Format the 8.1 (At the moment I assume it's "hh;mm") as "general" this will give you the time as a decimal fraction of a day.
    Multiply this by 24, Divide this by your 10 hrs then multilpy by 100
    Please Login or Register  to view this content.
    Regards Mick

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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