Time Conversion 100 minutes to 60 minutes

Diannelea

New Member
Joined
Jul 2, 2012
Messages
8
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.

o_O

Thank you!
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Can you post some "before" and "after" examples of what the software displays and what you want the new value to be?
 
Upvote 0
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 ?
 
Upvote 0
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:
Upvote 0
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 ...
 
Upvote 0
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?
 
Upvote 0
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
ABC
160 Minute Clock HH:MMAdd this time in minutesResult HH:MM
278:441879:02
378:445579:39
478:4410080:24
Sheet1
Cell Formulas
RangeFormula
C2=A2+TIME(0,B2,0)
C3=A3+TIME(0,B3,0)
C4=A4+TIME(0,B4,0)
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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?
 
Upvote 0

Forum statistics

Threads
1,213,562
Messages
6,114,326
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top