Creating a Time Sheet for Attorney Billing

**wowsley** · 08-06-2008, 04:09 PM

All,
I am new to the forum and sadly, not a great Excel user

I am however trying to create a time sheet for a template and am having the hardest time. I can't find examples on the web or anything that would help, so I bring my troubles, humblely to you all!

What I am attempting to do is to allow the attorney's to enter a start time and an end time. In the total section, it would calculate the total time spent (to the tenth of the hour) and then multiply that time spent by the hourly rate, thus giving the attorney the amount to bill for. Seems simple, right? Ha!

Any suggestions would be wonderous at this point as I now have brain leaking from my ears!

Regards,
Wes

**protonLeah** · 08-06-2008, 04:23 PM

Your original formula:

Please Login or Register  to view this content.

should be:

Please Login or Register  to view this content.

with the cells formatted as number/1 decimal place

**wowsley** · 08-06-2008, 04:28 PM

I can't believe the speed at which you replied...thanks alot. I will do both of your suggestions and see how it goes. Thanks Again,

Wes

**wowsley** · 08-06-2008, 04:37 PM

okay so what am I doing wrong here? You suggestions seem right to me but for some reason its still not calculating time right. What should I do about the whole "What if I start in the AM and finish in the PM" thing? Also, please note that with the change you have suggested the total (I18) seems wrong to me but it could be a function of the other total cells being wrong. Any ideas would be most appreciated!

**protonLeah** · 08-06-2008, 08:50 PM

In your TOTALS column, you only reformatted the Monday cell as number...
the remaining cells were left as (o'clock) TIME, thus the 54:00 (o'clock) value. When reformatted it becomes 2.3 (hours) as needed. Since the daily totals are then numbers you just add the range:

Please Login or Register  to view this content.

**wowsley** · 08-07-2008, 07:21 AM

I have seen the error of my ways! Wamest Regards to your all! I will be around from now on looking around as it seems some of my future days will be spent deep in the XL world.