Forum Discussion

Mark_74's avatar
Mark_74
Copper Contributor
Nov 07, 2019

Basic Formulas in Excel

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.

 

excel

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Nov 09, 2019

    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)

Resources