close

I'm trying to make 3 rows. The first is hours and minutes, the second is
wage, and the third is total. I tried using one of Office XP Professional
formula's, but its not exact. I think thats because its counting the
time wrong, but am not sure. Any help would be apprecitated.Thank you,
Tom
=A1*B1*24

Time in Excel is stored as a fraction of a day, so 1 hour = 1/24

--
Kind regards,

Niek Otten

quot;Tomquot; gt; wrote in message
...
gt; I'm trying to make 3 rows. The first is hours and minutes, the second is
gt; wage, and the third is total. I tried using one of Office XP Professional
gt; formula's, but its not exact. I think thats because its counting the
gt; time wrong, but am not sure. Any help would be apprecitated.
gt;
gt;
gt; Thank you,
gt; Tom
gt;
gt;
Sorry, confused Columns and Rows

=A1*A2*24

--
Kind regards,

Niek Otten

quot;Niek Ottenquot; gt; wrote in message
...
gt; =A1*B1*24
gt;
gt; Time in Excel is stored as a fraction of a day, so 1 hour = 1/24
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Tomquot; gt; wrote in message
gt; ...
gt;gt; I'm trying to make 3 rows. The first is hours and minutes, the second is
gt;gt; wage, and the third is total. I tried using one of Office XP
gt;gt; Professional
gt;gt; formula's, but its not exact. I think thats because its counting the
gt;gt; time wrong, but am not sure. Any help would be apprecitated.
gt;gt;
gt;gt;
gt;gt; Thank you,
gt;gt; Tom
gt;gt;
gt;gt;
gt;
gt;
See previous post.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Tomquot; gt; wrote in message
...
gt; I'm trying to make 3 rows. The first is hours and minutes, the second is
gt; wage, and the third is total. I tried using one of Office XP Professional
gt; formula's, but its not exact. I think thats because its counting the
gt; time wrong, but am not sure. Any help would be apprecitated.
gt;
gt;
gt; Thank you,
gt; Tom
gt;
gt;
PLEASE POST YOUR QUESTION ONCE AND ONLY ONCE!

This is your third posting of the same problem.

See my answer to your first post

quot;Tomquot; wrote:

gt; I'm trying to make 3 rows. The first is hours and minutes, the second is
gt; wage, and the third is total. I tried using one of Office XP Professional
gt; formula's, but its not exact. I think thats because its counting the
gt; time wrong, but am not sure. Any help would be apprecitated.
gt;
gt;
gt; Thank you,
gt; Tom
gt;
gt;
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()