how do i convert time into decimals for my timesheet?
Question : how do i convert time into decimals for my timesheet?
how do i convert time into decimals for my timesheet? for example i go in at 6:45am and get out at 7:00pm.
timesheet
Best answer:
Answer by Goyo
Every 15 minutes is a 1/4 of an hour, so 15 min = 0.25 hr
Therefore, 6:45am to 6:45pm would be 12 hours
and, 6:45pm to 7:00pm would be 15 min
So, enter on your timesheet: 12.25 hrs.
Here is an easy way to do any sort of conversion. In this case the problem you are facing is converting the minute portion of your time, so you want to convert the minutes to hours (expressed as a decimal).
You know that anything multiplied by 1 will be itself, right? You also know that anything divided by itself is also 1 (3/3=1, -9/-9=1, etc.). You also know that 60 minutes is 1 hour. Therefore if we express 1 hr/60 min. this also would equal 1 (1 hr = 60 min, therefore this is esentially the same number divided by itself and thus equal to 1)
Now take the portion that you want converted and multiply it by 1 expressed as a fraction with the units you want eliminated as the denominator (bottom number) and the units you want to convert to as the numerator (top number). In this case:
15 min/1 * (1hr/60min)
Think of the units as variabalbes (x or y). We know that in this sort of multiplication problem we would be able to eliminate like variables that are expressed in the numerators and the denominators of either numbers in our equation. Thus we can cross out the “min” in both the numerator of the first number (expressed as 15min/1, which you should know is 15 min) and the “min” in the denominator of the second number. After doing this we are only left with the hr unit and can comple the eqation (15/60)hr or .25 hr.
I probably didn’t explain that too well, so if you want it broken down by minute, here it is:
1min=0.017hrs
2min=0.033hrs
3min=0.050hrs
4min=0.067hrs
5min=0.083hrs
6min=0.100hrs
7min=0.117hrs
8min=0.133hrs
9min=0.150hrs
10min=0.167hrs
11min=0.183hrs
12min=0.200hrs
13min=0.217hrs
14min=0.233hrs
15min=0.250hrs
16min=0.267hrs
17min=0.283hrs
18min=0.300hrs
19min=0.317hrs
20min=0.333hrs
21min=0.350hrs
22min=0.367hrs
23min=0.383hrs
24min=0.400hrs
25min=0.417hrs
26min=0.433hrs
27min=0.450hrs
28min=0.467hrs
29min=0.483hrs
30min=0.500hrs
31min=0.517hrs
32min=0.533hrs
33min=0.550hrs
34min=0.567hrs
35min=0.583hrs
36min=0.600hrs
37min=0.617hrs
38min=0.633hrs
39min=0.650hrs
40min=0.667hrs
41min=0.683hrs
42min=0.700hrs
43min=0.717hrs
44min=0.733hrs
45min=0.750hrs
46min=0.767hrs
47min=0.783hrs
48min=0.800hrs
49min=0.817hrs
50min=0.833hrs
51min=0.850hrs
52min=0.867hrs
53min=0.883hrs
54min=0.900hrs
55min=0.917hrs
56min=0.933hrs
57min=0.950hrs
58min=0.967hrs
59min=0.983hrs
60min=1.000hrs