Time sheet minute to tenths converter


NOTE: This is the only time card calculator on this website in which the minutes are input as hundredths of an hour.. For example, 9:30 a.m. is input as 9.50 and 1:45 is input as 1.75. Convert Time to Minutes in Excel. Cell B2 of the spreadsheets below show the two formulas that can be used to convert a time to a number of minutes in Excel. Method 1: Simple Multiplication. The simplest way to convert a time to a number of minutes is to multiply the time by 1440, which is equal to 24*60 (the number of minutes in one day): From the hour mark to 6 minutes = 0 time paid Over 7 minutes to 15 minutes = 1/4 hour 15 16 minutes to 30 minutes = 1/2 hour 30 30 minutes to 45 minutes = 3/4 hour 45 46 minutes to 60 minutes = one hour. They work on shifts and the operation is 24 hours. Each gets 30 minutes for breaks which is not paid. Minutes to Decimal Conversion Chart Below is a chart to help you convert minutes to decimals for use with MCtime. Minutes Decimals Minutes Decimals 1 0.02 31 0.52 2 0.03 32 0.53 3 0.05 33 0.55 4 0.07 34 0.57 5 0.08 35 0.58 6 0.10 36 0.60 7 0.12 37 0.62 8 0.13 38 0.63 9 0.15 39 0.65 10 0.17 40 0.67 11 0.18 41 0.68 12 0.20 42 0.70 Chart to Convert Minutes to Tenths of An Hour Minutes to be reported _____ Tenth of Hour reported _____ Minutes to be reported