there is a formula that I believe exists but I have no idea how to make it happen. We use a sheet in our accounting office (attached) to track who has worked on a particular tax return and how much time they have spent. We also have chargeable services on the same sheet, so when the return is done the billable time is calculated and added to the service charges for a grand total.
I would like to have employee initials attached to their hourly billable rate, so when they enter their initials and the time (.25 equals 15 minutes and so on) the billable total is displayed at the end of the row. I then would like the billable section to subtotal at the bottom but then get added with the services running total to create the grand total.
Please let me know if this is possible, it would greatly reduce time spent and billing mistakes. If somebody thinks they can help I can also send the form that I want to use via email.
Thank you,
Bookmarks