adding and multiplying hours in Excel

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: adding and multiplying hours in Excel

  1. #1
    New Member
    Join Date
    Nov 2002
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I am recording hours worked per day as
    5:40 (5 hours, 40 minutes)
    6:10
    8:20
    6:40
    which totals 26:50. (26 hours, 50 minutes)

    However, when I then try to multiply the total hours:minutes by an hourly rate (60), I get an incorrect answer (I get 67.08333333). Is there a trick for this?

    Thanks.

  2. #2
    MrExcel MVP
    Join Date
    May 2002
    Posts
    14,181
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    multiply your hours by 24 first.

    see links on previous post:

    http://216.92.17.166/board/viewtopic...8872&forum=2&4

    for more info

    paddy

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com