hours and minutes multiplied by wage

[Tom]

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

 

[Niek Otten]

=A1*B1*24

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

 

[Niek Otten]

Sorry, confused Columns and Rows

=A1*A2*24

 

[Bob Phillips]

See previous post.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

PLEASE POST YOUR QUESTION ONCE AND ONLY ONCE!

This is your third posting of the same problem.

See my answer to your first post