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;
- Apr 21 Sat 2007 20:36
hours and minutes multiplied by wage
close
全站熱搜
留言列表
發表留言