Basic Formulas in Excel

[Mark_74]

Hi,

    I have a spreadsheet for invoicing that I have produced for the business which has various information on it (charge rate, pay rate, mark up) each week I input the hours worked that week for the individual and it calculates the amount to pay and charge. The problem is I have trouble if someone has only worked 6 hrs & 17 minutes as I have no definitive way of calculating this.

I have tried to format the cells but it only offers me the time.

[#2]

@Mark_74 

17 minutes = 17/60 hours = 0.283333333 hours

6 hours + 17 minutes  would thus equal 6.2833333 hours.

[#3]

@Mark_74 

Other words, it's suitable to keep time format for the cells, enter the time in natural format, e.g 6:17, but in calculations use =A1*24 (if time is in A1)