Results 1 to 2 of 2

adding and multiplying hours in Excel

This is a discussion on adding and multiplying hours in Excel within the Excel Questions forums, part of the Question Forums category; 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 ...

  1. #1
    New Member
    Join Date
    Nov 2002
    Posts
    11

    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
    13,993

    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

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