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 "topping over"
at 24 hrs.

--
Kind regards,

Niek Otten

"Webitect" wrote in message
...
Hello,

Could anyone help me out with this? I have two columns, one calculates
the amount of time spent from a "time in" column and a "time out" 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 "total time" 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