TIME : MINUTES = HOURS
TIME : MINUTES = HOURS
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: TIME : MINUTES = HOURS

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    1,451
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have a sheet with in column A1:A20 fillid with minutes.I want a formale that gives me in cell A21 the sum in hours and minutes:
    EX:

    120
    75
    20
    150

    SUM : 6,12

    Many thanks

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Florida
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Not sure but I am thinking =sum(a1:a20)/60
    format cell as number......

    Denny

    [ This Message was edited by: kinkyparamour on 2002-04-12 08:28 ]

    [ This Message was edited by: kinkyparamour on 2002-04-12 08:29 ]

  3. #3
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,445
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try
    =sum(a1:a20)/1440

    Example you gave should be 6 hours 5 mins

    Format A21 to time

    [ This Message was edited by: Brian from Maui on 2002-04-12 08:33 ]

  4. #4
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    =SUM(A1:A20)/1440 and format cell as h,mm. for the data you provided this displays 6,05

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Location
    Florida
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Guys,

    I see where your formula is right and mine is way off. Could you please explain what the 1440 represents?

    Denny

  6. #6
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,445
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-12 08:53, kinkyparamour wrote:
    Hi Guys,

    I see where your formula is right and mine is way off. Could you please explain what the 1440 represents?

    Denny
    1440 is the number of minutes in a day

  7. #7
    Board Regular
    Join Date
    Feb 2002
    Location
    Florida
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you, now it makes sence to me.....Sometimes it's the little things that get in the way.....

    Denny

    [ This Message was edited by: kinkyparamour on 2002-04-12 09:03 ]

  8. #8
    Board Regular
    Join Date
    Apr 2002
    Location
    Cape Town,South Africa
    Posts
    234
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    OK Here is a good example of a function which I use to convert time on my payrolls

    =INT(E10/60)&" hours "&MOD(E10,60)& " minutes"


    the E10 is where the minutes is

    It will give you exp.18hours15minutes

    And when you devide it by 60 it will give you 18.3333333 which is 18 and a third which is wrong.



  9. #9
    Board Regular
    Join Date
    Apr 2002
    Location
    Cape Town,South Africa
    Posts
    234
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    OK Here is a good example of a function which I use to convert time on my payrolls

    =INT(E10/60)&" hours "&MOD(E10,60)& " minutes"


    the E10 is where the minutes is

    It will give you exp.18hours15minutes

    And when you devide it by 60 it will give you 18.3333333 which is 18 and a third which is wrong.



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