Time Conversion 100 minutes to 60 minutes

[Diannelea]

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!

 

[Ron Coderre]

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

 

[AlphaFrog]

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 ?

 

[Diannelea]

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

 

[Diannelea]

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 ...

 

[Ron Coderre]

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?

 

[AlphaFrog]

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:
<br />

Book1
	A	B	C
1	60 Minute Clock HH:MM	Add this time in minutes	Result HH:MM
2	78:44	18	79:02
3	78:44	55	79:39
4	78:44	100	80:24
Sheet1

Cell Formulas
Range	Formula
C2	=A2+TIME(0,B2,0)
C3	=A3+TIME(0,B3,0)
C4	=A4+TIME(0,B4,0)

 

[Diannelea]

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

 

[Diannelea]

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

 

[Diannelea]

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?