Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Time Conversion 100 minutes to 60 minutes

This is a discussion on Time Conversion 100 minutes to 60 minutes within the Excel Questions forums, part of the Question Forums category; There is a lot of material out there on how to do that. But, how do I prove to the ...

  1. #1
    New Member
    Join Date
    Jul 2012
    Location
    Florida
    Posts
    8

    Default Time Conversion 100 minutes to 60 minutes

    There is a lot of material out there on how to do that. But, how do I prove to the employee that he/she is getting what they are suppose to be paid? Our time clock is 60 minutes while the input software to be paid runs on a 100 minute clock.



    Thank you!

  2. #2
    MrExcel MVP Ron Coderre's Avatar
    Join Date
    Jan 2009
    Location
    Massachusetts, USA
    Posts
    1,786

    Default Re: Time Conversion 100 minutes to 60 minutes

    Can you post some "before" and "after" examples of what the software displays and what you want the new value to be?
    Best Regards,

    Ron Coderre
    Microsoft MVP-Excel (Oct 2006 - Sep 2015)
    Using: Excel 2010 & 2013

  3. #3
    MrExcel MVP AlphaFrog's Avatar
    Join Date
    Sep 2009
    Posts
    12,004

    Default Re: Time Conversion 100 minutes to 60 minutes

    Quote Originally Posted by Diannelea View Post
    There is a lot of material out there on how to do that. But, how do I prove to the employee that he/she is getting what they are suppose to be paid? Our time clock is 60 minutes while the input software to be paid runs on a 100 minute clock.
    Are you trying to convert 100 minutes to H:MM e.g. 1:40 or decimal hours 1.6667 ?
    Paste your Excel data to the forum...
    MrExcel HTML Maker or Excel Jeanie

    Please surround your pasted VBA code with CODE tags e.g.;
    [CODE] your VBA code here [/CODE]
    The pound # icon in the forum editor will apply the CODE tags around your selected text.

  4. #4
    New Member
    Join Date
    Jul 2012
    Location
    Florida
    Posts
    8

    Default Re: Time Conversion 100 minutes to 60 minutes

    Examples and Thanks for your kindness, I am grateful!

    our Time Clock tracks every minute and is a 60 minute clock
    software Input 100 Minute Clock set to 15 minute increments

    60 Minute Clock
    78:44 Regular Time
    OT :18

    Totals
    60 minute clock Totals 79:02
    100 Minute Clock 78:62


    I input as 78:77 + .25 does equal the 79.02 but prefer not to have to do that guy gets paid more


    78:55
    :55
    totals

    60 Minute clock 79:55 1
    100 minute clock totals 79:10


    Thanks for your assistance It appears to me that the 100 miute clock adds what is there together the 60 minute clock you have to add the minutes and divide by 60 first then the hours.

    I have a chart that shows a 100 minute clock conversion, but the calculation for .18 is .3 that just doesn't work. So how do I do this and explain to these hard working people that $ are the same but arent?.

    Thanks a lot
    Last edited by Diannelea; Jul 3rd, 2012 at 08:57 AM. Reason: text not lined up properly

  5. #5
    New Member
    Join Date
    Jul 2012
    Location
    Florida
    Posts
    8

    Default Re: Time Conversion 100 minutes to 60 minutes

    Quote Originally Posted by Diannelea View Post
    Examples and Thanks for your kindness, I am grateful!

    our Time Clock tracks every minute and is a 60 minute clock
    software Input 100 Minute Clock set to 15 minute increments

    60 Minute Clock
    78:44 Regular Time
    OT :18

    Totals
    60 minute clock Totals 79:02
    100 Minute Clock 78:62


    I input as 78:77 + .25 does equal the 79.02 but prefer not to have to do that guy gets paid more


    78:55
    :55
    totals

    60 Minute clock 79:55 1
    100 minute clock totals 79:10


    Thanks for your assistance It appears to me that the 100 miute clock adds what is there together the 60 minute clock you have to add the minutes and divide by 60 first then the hours.

    I have a chart that shows a 100 minute clock conversion, but the calculation for .18 is .3 that just doesn't work. So how do I do this and explain to these hard working people that $ are the same but arent?.

    Thanks a lot
    I want to have apples and apples and not oranges and apples. The input for time must match the time cards (60 minute) clock and the pay must be the same either way. So converting 60 to 100 doesn't really work ...

  6. #6
    MrExcel MVP Ron Coderre's Avatar
    Join Date
    Jan 2009
    Location
    Massachusetts, USA
    Posts
    1,786

    Default Re: Time Conversion 100 minutes to 60 minutes

    Maybe I'm just being dense...but...can you define the parts of each "time"?
    60 minute clock... 79:02
    • Is that 79 hours and 2 minutes?

    100 minute clock... 78:62
    • Is that 78 hours and 62 minutes?
    • 78.62 hours?
    • something else?
    Best Regards,

    Ron Coderre
    Microsoft MVP-Excel (Oct 2006 - Sep 2015)
    Using: Excel 2010 & 2013

  7. #7
    MrExcel MVP AlphaFrog's Avatar
    Join Date
    Sep 2009
    Posts
    12,004

    Default Re: Time Conversion 100 minutes to 60 minutes

    Quote Originally Posted by Diannelea View Post
    Examples and Thanks for your kindness, I am grateful!

    our Time Clock tracks every minute and is a 60 minute clock
    software Input 100 Minute Clock set to 15 minute increments

    60 Minute Clock
    78:44 Regular Time
    OT :18

    Totals
    60 minute clock Totals 79:02
    100 Minute Clock 78:62


    I input as 78:77 + .25 does equal the 79.02 but prefer not to have to do that guy gets paid more


    78:55
    :55
    totals

    60 Minute clock 79:55 1
    100 minute clock totals 79:10


    Thanks for your assistance It appears to me that the 100 miute clock adds what is there together the 60 minute clock you have to add the minutes and divide by 60 first then the hours.

    I have a chart that shows a 100 minute clock conversion, but the calculation for .18 is .3 that just doesn't work. So how do I do this and explain to these hard working people that $ are the same but arent?.

    Thanks a lot
    This is how Excel stores time...
    How Excel Stores Dates And Times

    If you have a time value in Excel HH:MM (60 minute clock) and you want to add minutes to that time (100 minute clock), you must convert the minutes to time, then you add that to your existing time.

    Example:

    ABC
    160 Minute Clock
    HH:MM
    Add this time in minutesResult HH:MM
    278:441879:02
    378:445579:39
    478:4410080:24


    Worksheet Formulas
    CellFormula
    C2=A2+TIME(0,B2,0)
    C3=A3+TIME(0,B3,0)
    C4=A4+TIME(0,B4,0)

    Paste your Excel data to the forum...
    MrExcel HTML Maker or Excel Jeanie

    Please surround your pasted VBA code with CODE tags e.g.;
    [CODE] your VBA code here [/CODE]
    The pound # icon in the forum editor will apply the CODE tags around your selected text.

  8. #8
    New Member
    Join Date
    Jul 2012
    Location
    Florida
    Posts
    8

    Default Re: Time Conversion 100 minutes to 60 minutes

    Quote Originally Posted by Ron Coderre View Post
    Maybe I'm just being dense...but...can you define the parts of each "time"?
    60 minute clock... 79:02
    • Is that 79 hours and 2 minutes?

    100 minute clock... 78:62
    • Is that 78 hours and 62 minutes?
    • 78.62 hours?
    • something else?
    Hi,
    the .18 is overtime minutes the 60 minute clock and the 100 minute clock treat it differently.
    What I want to do is make sure that that 18 minutes is paid the same either way. Does that help? I apologize for not being clear
    about the overtime. The numbers we are looking at are the actual totals on the time card.

    The .18 is the overtime. We get paid bi monthly which is another wrinkle altogether.
    so it is not just minutes but time and 1/2 minutes.

    thank you
    Dianne Rabkin

  9. #9
    New Member
    Join Date
    Jul 2012
    Location
    Florida
    Posts
    8

    Default Re: Time Conversion 100 minutes to 60 minutes

    also the 78.62 was the total that the 100 minute clock added those 2 sets of numbers
    while the 79.02 was the 60 minute clock.
    .18 is the overtime on the time card and both must add up (with equal pay) to the same $ amount.
    So converting to time is a good idea, but part of that time must be overtime and both clocks must equal to pay the same $.

    hope that helps

  10. #10
    New Member
    Join Date
    Jul 2012
    Location
    Florida
    Posts
    8

    Default Re: Time Conversion 100 minutes to 60 minutes

    I enter 7.59 munutes, which converts to 7:35 and at $10 an hour, am employee is paid $75.83. enter 7.59 the employee is paid $75.90. An employee making $10 an hour and worked 7 hours 59 minutes should be paid closer to $80.

    Is there a formula to use that does this so that we can show the employee he is getting the right $ amount?

Page 1 of 2 12 LastLast

Tags for this Thread

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