software

Hello,

Could anyone help me out with this? I have two columns, one calculates the
amount of time spent from a quot;time inquot; column and a quot;time outquot; column. The
other column calculates the amount of money made (or lost) from a starting
balance to an ending balance. I am trying to get another column to
calculate $/Hr. I can't get it to work for some reason. Also, when I try
to add up the total amount of time in the quot;total timequot; column, it'll only
add a few cells correctly...anymore than 5 cells it won't report anything.

Any advice would be greatly appreciated.

Sincerely,

Ray
Hi Ray,

=A1*A2*24 (since times are stored as fractions of a day so 1 means 24 hrs
and 1 hr is stored as 1/24th.
To add times, format the total as Custom, [h]:mm. This avoids quot;topping overquot;
at 24 hrs.

--
Kind regards,

Niek Otten

quot;Webitectquot; gt; wrote in message
...
gt; Hello,
gt;
gt; Could anyone help me out with this? I have two columns, one calculates
gt; the amount of time spent from a quot;time inquot; column and a quot;time outquot; column.
gt; The other column calculates the amount of money made (or lost) from a
gt; starting balance to an ending balance. I am trying to get another column
gt; to calculate $/Hr. I can't get it to work for some reason. Also, when I
gt; try to add up the total amount of time in the quot;total timequot; column, it'll
gt; only add a few cells correctly...anymore than 5 cells it won't report
gt; anything.
gt;
gt; Any advice would be greatly appreciated.
gt;
gt; Sincerely,
gt;
gt; Ray
gt;
You need to make the time into decimal time, e.g.

Assume you have 12:30 in A1, since one excel hour is 1/24 (1 = one day in
excel) so you need to multiply the time with 24 first, same as if you want a
total of hours multiplied by a payrate

=A1*24

or

=amount/(A1*24)

or

=round(amount/(A1*24),2)

rounded to the nearest cent

note that you must format the result as general, number or currency or else
Excel tries to be helpful and sensing a time value will format result as
time (stupid really)

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;Webitectquot; gt; wrote in message
...
gt; Hello,
gt;
gt; Could anyone help me out with this? I have two columns, one calculates
gt; the amount of time spent from a quot;time inquot; column and a quot;time outquot; column.
gt; The other column calculates the amount of money made (or lost) from a
gt; starting balance to an ending balance. I am trying to get another column
gt; to calculate $/Hr. I can't get it to work for some reason. Also, when I
gt; try to add up the total amount of time in the quot;total timequot; column, it'll
gt; only add a few cells correctly...anymore than 5 cells it won't report
gt; anything.
gt;
gt; Any advice would be greatly appreciated.
gt;
gt; Sincerely,
gt;
gt; Ray
gt;