Forum Discussion
Mark_74
Nov 07, 2019Copper Contributor
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...
SergeiBaklan
Nov 09, 2019Diamond Contributor
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)