I recently was put in charge of payroll at my job, and can't quite seem to wrap my head around converting hours into decimals. We break it down to 1/4 hours. Math is like a foreign language to me! If there was some sort of converter that I could, say, put in the time someone clocked in, and the time they clocked out, and then it would tell me that they worked (for example) 7.75 hours. Are there any software programs that will accomplish this for me? Or maybe a website with some sort of javascript? Or maybe an excell formula? I am at the mercy of technology! Pretend that I'm in the 3rd grade. ;) I need to figure out how to get the decimal number. Example: John clocks in at 8:02am. He clocks out for lunch at 11:46am and clocks back in at 12:16pm. He clocks out for the day at 2:17pm. How do I get the hours worked in decimal form?
2007-05-26 13:48:57 · 12 answers · asked by dave_g_28 2 in Science & Mathematics ➔ Mathematics
http://www.tucows.com/preview/249455
Thousands of programs!!!
2007-05-26 14:34:03 · answer #1 · answered by jake cigar™ is retired 7 · 2⤊ 0⤋
Divide by 60 --- there are 60 minutes in an hour, right?
If someone works what you said, that's 3 hours and 44 minutes, right? Divide 44 by 60 -- you get 0.73 -- that's closest to 0.75 -- so in the morning John worked 3.75 hours.
12:16 to 2:17 is 2 hours and 1 minute. 1 divided by 60 is 0.01 which is certainly too small to give credit for. But really, that's a more difficult way to do it.
Just remember 15 - 30- 45 - minutes are equal to 0.25 - 0.50 and 0.75.
Look at the clock -- if you divided it in half and then half again, you have your fourths or quarters. -- once you add up all the hours and the minutes leftover -- then your minutes will always be under 60 ----
1/4 = .25 hour = 15 minutes
1/2 = .50 hour = 30 minutes
3/4 = .75 hour = 45 minutes
If you can't remember those 3 things, maybe payroll isn't your cup of tea.
I don't know your rules on rounding up or down -- ours was 8 minutes. In otherwords, if you had 38 minutes, it rounded up to 45 minutes, which is 3/4 or 0.75
but the dividing by 60 thing won't help much here, because 38 divided by 60 = 0.63 -- now, do you round up or down?
WAY TOO CONFUSING!!!!
I don't know of any programs, but good luck.
2007-05-26 14:12:09 · answer #2 · answered by prisssygirrl 2 · 0⤊ 0⤋
Hours In Decimals
2016-10-04 01:52:52 · answer #3 · answered by salguero 4 · 0⤊ 0⤋
Get a calculator and just remember 60 and 12 noon.
If the time in the afternoon (after 12) add 12 to the hour.
Take the minutes and divide by 60.
This give you two numbers. The hour goes before the decimal and the minutes/60 goes after.
For example 2:13 pm.
2 is after 12 so make it 12+2 or 14.
13/60 = .22 (rounded)
Put them together 14.22
That is all there is.
Arrive at 9:00 am = 9.00
Lunch at 12:03 pm = 12.05
Return at 12:37 pm = 12.62
Home at 5:31 pm= 17.52
AM = 12.05 - 9.00 = 3.05
PM = 17.52-12.62 = 4.9
Total = 7.95 hours
2007-05-26 14:00:47 · answer #4 · answered by Barkley Hound 7 · 0⤊ 0⤋
Just use this table : 15 minutes = .25 hours : 30 minutes = .50 hours : 45 minutes = .75 hours
Or think in quarters (like money) 1 quarter is .25, 2 quarters is .50 and 3 quarters is .75
John = 3.75 + 2.00 or 5.75 hours. 11:46 - 8:02 = 3:44 or 3 3/4 or 3 and 3 quarters or 3.75. 2:17 - 12:16 = 14:17 - 12:16 = 2:01 or just 2.00. Add to get 5.75 hours.
2007-05-26 14:10:09 · answer #5 · answered by Don E Knows 6 · 0⤊ 0⤋
Every 6 minutes is 0.1 hours. This is the way most companies compute time worked. Generally, if an employee is supposed to be at work at 8am, and clocks into work at 8:03, works until 4, he has worked 7.9 hours. As a matter of fact, he would not have 8 hours until he worked until 4:06. It is acceptable to round up to the next our for 12 minutes. such as an employee clocks in at 7:48 and works until 4. He is only paid 8 hours.
2007-05-26 14:08:25 · answer #6 · answered by Ace 1 · 0⤊ 0⤋
Hours + Minutes/60 For example: 31 + 36/60 = 31 + 6/10 = 31.6 Or: 24 + 24/60 = 24 + 2/5 = 24.4 Now you try it: 4 + 52/60 = ??
2016-03-13 00:13:48 · answer #7 · answered by Anonymous · 0⤊ 0⤋
11:46----14:17
08:02----12:16
_____---_____
03:43----02:01
Time worked = 5:44
To nearest 15 mins this is 5h 45mins = 5.75 h
If you are working always to nearest 15 mins, the decimals you need are:-
15mins = 1/4 h = 0.25 h
30mins = 1 / 2 h = 0.5 h
45 mins = 3 / 4 h = 0 .75 h
2007-05-27 01:11:08 · answer #8 · answered by Como 7 · 0⤊ 0⤋
You have two conversion factors. The first one is easy, to change your 12 hour times to 24 hour times. Add 12 to every hour after 12 noon. Therefore your clock out time of 2:17 would actually be 14.17. The second conversion is to change your minutes to hundreths of units. This is done by dividing the minutes by 6. You would list your times therefore as 2:17 = 14.28, 12:16 = 12.26, 11:46 = 11.76, and 8:02 = 8.03. Then calculate ((14.28 - 12.26) + (11.76 - 8.03)) =
Been there done that!
ADDED: The answer above is also correct. If your employee was supposed to start work at 8 am, and clocked in at 8:02, he is technically late. It would be up to your human resource department to determine if they want to dock him for the time. However if he was supposed to start work at 8:15 or 8:30, his time should be calculated from the actual starting time, not the time he clocked in. The same theory holds true for clocking out. If he was supposed to stop work at 2:15 and clocked out at 2:17, his time should be calculated to 2:15. However if he was supposed to stop work at 2:30, his clock out time should be the calculating factor.
2007-05-26 14:08:39 · answer #9 · answered by rb_cubed 6 · 0⤊ 0⤋
I only can work 3.75 hours a day. I clock in at 8am, what time do I clock out.
2017-01-30 01:03:49 · answer #10 · answered by Maretha 1 · 0⤊ 0⤋
Just divide the minutes by 60. Like 45 minutes divided by 60 = .75
16 minutes divided by 60 = .26 (rounded off, it would be 15 minutes, or .25, but you knew that).
2007-05-26 13:53:47 · answer #11 · answered by Anonymous · 0⤊ 0⤋