# Calculating hours for a timesheet

1. ## Calculating hours for a timesheet

I am trying to create a worksheet where I can enter my start & end times and
then use that figure to calculate my hourly fee in dollars. I have separate
columns for the start & end times, another column that calculates what the
difference between those is (but it shows it in h:mm format), so I have
another column that converts that to a decimal (using the INT function), a
column that has the hourly fee & a column for the final rate. Is there a way
to eliminate the extra column with the h:mm format?  Register To Reply

2. ## Re: Calculating hours for a timesheet

=(C4-B4)*24*D4

Where
C4 = finisht time
B4 = start Time
D4 = hourly rate

If you want to understand more about dates and times see:
http://www.cpearson.com/excel/datetime.htm

Steve

"Niq" <Niq@discussions.microsoft.com> wrote in message
news:36DA3998-BBC9-4F6F-A962-CD06DF99AEFE@microsoft.com...
>I am trying to create a worksheet where I can enter my start & end times
>and
> then use that figure to calculate my hourly fee in dollars. I have
> separate
> columns for the start & end times, another column that calculates what the
> difference between those is (but it shows it in h:mm format), so I have
> another column that converts that to a decimal (using the INT function), a
> column that has the hourly fee & a column for the final rate. Is there a
> way
> to eliminate the extra column with the h:mm format?  Register To Reply

3. ## Calculating hours for a timesheet

Hi!

You can eliminate the difference column and the decimal
column:

A2 = Start
B2 = End
C2 = Difference
D2 = Decimal value
E2 = Hourly fee

=(B2-A2+(A2>B2))*24*E2

Biff

>-----Original Message-----
>I am trying to create a worksheet where I can enter my

start & end times and
>then use that figure to calculate my hourly fee in

dollars. I have separate
>columns for the start & end times, another column that

calculates what the
>difference between those is (but it shows it in h:mm

format), so I have
>another column that converts that to a decimal (using the

INT function), a
>column that has the hourly fee & a column for the final

rate. Is there a way
>to eliminate the extra column with the h:mm format?
>.
>  Register To Reply

4. ## Re: Calculating hours for a timesheet

Biff's function takes working past midnight into account.

"Steve" <swrtree@hotmail.com> wrote in message
news:42224ab4@dnews.tpgi.com.au...
> =(C4-B4)*24*D4
>
> Where
> C4 = finisht time
> B4 = start Time
> D4 = hourly rate
>
> If you want to understand more about dates and times see:
> http://www.cpearson.com/excel/datetime.htm
>
> Steve
>
>
>
> "Niq" <Niq@discussions.microsoft.com> wrote in message
> news:36DA3998-BBC9-4F6F-A962-CD06DF99AEFE@microsoft.com...
>>I am trying to create a worksheet where I can enter my start & end times
>>and
>> then use that figure to calculate my hourly fee in dollars. I have
>> separate
>> columns for the start & end times, another column that calculates what
>> the
>> difference between those is (but it shows it in h:mm format), so I have
>> another column that converts that to a decimal (using the INT function),
>> a
>> column that has the hourly fee & a column for the final rate. Is there a
>> way
>> to eliminate the extra column with the h:mm format?

>
>  Register To Reply