Results 1 to 5 of 5

Thread: Excel question

  1. #1
    Senior Member EviLClouD's Avatar
    Join Date
    Oct 2007
    Posts
    241

    Default Excel question

    Hey, is there any way to make excel display time in hrs/mins and using that value to calculate pay?
    Ie someone worked 4hrs 35min @ $10p/h = $45.83

    In excel i would normally have to write it as 4.58 hours. Is there anyway to convert it so i can write it as 4.35 hrs?

    Thanks!

  2. #2
    Short Member pcuser42's Avatar
    Join Date
    Apr 2006
    Location
    Pukekohe Shuttle
    Posts
    10,117

    Default Re: Excel question

    Format the cell as h:mm, then Excel can work it out.
    "He who resorts to personal insults hath lost the argument."

    Twitter

  3. #3
    Senior Member EviLClouD's Avatar
    Join Date
    Oct 2007
    Posts
    241

    Default Re: Excel question

    Hey yep i tried that. So if i type 3.25 and format as h:mm it shows up as 6:00 and in the formula bar it shows 3/01/1900 6:00:00 a.m.
    If i type 3:25 it shows up as 3:25:00 a.m.?

  4. #4

    Default Re: Excel question

    Hi - just tried it by entering the time as 4:35

    I then multiplied it by 24 (because excel treats the 4:35 as a percentage of a day) then by $10 and got the answer $45.83 as you had in your original post

    Trev

  5. #5
    Senior Member EviLClouD's Avatar
    Join Date
    Oct 2007
    Posts
    241

    Default Re: Excel question

    It worked! Thanks alot!

Similar Threads

  1. Excel question
    By WayneMiddy in forum PressF1
    Replies: 2
    Last Post: 02-12-2012, 10:10 PM
  2. Excel question
    By jcr1 in forum PressF1
    Replies: 3
    Last Post: 13-04-2010, 08:19 PM
  3. Excel Question
    By globe in forum PressF1
    Replies: 6
    Last Post: 09-06-2008, 05:19 PM
  4. Excel question
    By yorkshirekid in forum PressF1
    Replies: 12
    Last Post: 26-05-2007, 12:07 PM
  5. Excel Question
    By beeswax34 in forum PressF1
    Replies: 9
    Last Post: 29-04-2007, 04:57 PM

Posting Permissions

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