Can you post some "before" and "after" examples of what the software displays and what you want the new value to be?
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 ...
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!
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
Paste your Excel data to the forum...
MrExcel HTML Maker or Excel Jeanie
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in your menu for the forum editor will apply the CODE tags around your selected text.
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 07:57 AM. Reason: text not lined up properly
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
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:
A B C 1 60 Minute Clock
HH:MMAdd 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
Worksheet Formulas
Cell Formula 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
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in your menu for the forum editor will apply the CODE tags around your selected text.
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
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
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?
Like this thread? Share it with others