I recently started a home health job and have to keep my own time sheets. The problem is that I have to convert the hours into decimals. Ones such as 3 hrs and 30 minutes are easy (3.5) My problem is when I have to convert say 3 hrs and 20 minutes or 35 minutes. Can someone help me with this.
Please not silly answers I am reall serious about this. I would appreciate any good answers!!!
2006-06-20 12:15:29 · 11 answers · asked by ? 2 in Science & Mathematics ➔ Mathematics
well 3hrs 20 minutes is converted just like you do 3hrs 30 minutes. 20 divided 60 = .33 so it would be 3.33 hrs
2006-06-20 12:19:06 · answer #1 · answered by follownhim 2 · 4⤊ 0⤋
To convert minutes to a decimal fraction of an hour, simply divide the number of minutes by 60. You're probably limited to entering 1 or two decimal places, so you'll need to round your results.
Examples:
20 minutes = 20/60 hours = 0.33 hours
35 minutes = 35/60 hours = 0.58 hours
10 minutes = 10/60 hours = 0.17 hours
etc.
2006-06-20 19:20:57 · answer #2 · answered by hfshaw 7 · 0⤊ 0⤋
Convert any minute value into a decimal by dividing it by 60. For example, 30/60 = 0.5
Most people just round it to the nearest 1/4 hour for simplicity.
2006-06-20 19:19:59 · answer #3 · answered by Favoured 5 · 0⤊ 0⤋
If you're using a spreadsheet for your timesheets, use separate columns for the hours and minutes. Let's say the hours are in column A and the minutes in column B. Then column C, your exact time, is calculated with the formula A+B/60.
That adds the hours from column A with the fraction of hours from column B (converted from minutes to hours by dividing by 60 minutes per hour). There you have the decimal fraction of hours and minutes.
2006-06-20 19:36:35 · answer #4 · answered by poorcocoboiboi 6 · 0⤊ 0⤋
Simply divide the number of minutes extra by 60 like 25/60 and the result will be the decimal fraction you want.
2006-06-20 20:44:08 · answer #5 · answered by pechorin1 3 · 0⤊ 0⤋
Simple math: divide the 20 minutes or the 35 minutes by 60 minutes(hour) this will give you your answer.
2006-06-20 19:18:58 · answer #6 · answered by nswblue 6 · 0⤊ 0⤋
Simply divide the number of minutes by 60...this will give you the decimal. IE: 35 divided by 60 equals: 0.58 hours.
Good luck.
2006-06-20 19:19:55 · answer #7 · answered by Anonymous · 0⤊ 0⤋
Depends on how accurate you want... like tenths or hundreths
say tenths take the amount of time/minutes in an hour.. then round up to tenths or hundreths
so roughly every 6 minutes you will go up one tenth of an hour.
if you work 3 hours and 35 minutes your time will be 3.58 or 3.6
2006-06-20 19:21:23 · answer #8 · answered by bludyone 2 · 0⤊ 0⤋
1 hour = 60 minutes
x hours = 20 minutes
x= (20*1)/60
x=0.33 hours
And you can use whatever number of minutes you want to...
In portuguese we call this Regra de Três Simples ( three simple rule). you use it when you have 3 things that you know and a fourth that you don`t.
2006-06-21 09:33:25 · answer #9 · answered by Carla 4 · 0⤊ 0⤋
When I do my time sheets at work I do it in fractions...
Just cause it's easier for me to think in fractions.
Maybe that will help.
2006-06-20 22:20:33 · answer #10 · answered by Danielle K 3 · 0⤊ 0⤋