hours and minutes multiplied by wage
 

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

hours and minutes multiplied by wage
 

=A1*B1*24

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

--
Kind regards,

Niek Otten

"Tom" wrote in message
...
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

hours and minutes multiplied by wage
 

Sorry, confused Columns and Rows

=A1*A2*24

--
Kind regards,

Niek Otten

"Niek Otten" wrote in message
...
=A1*B1*24

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

--
Kind regards,

Niek Otten

"Tom" wrote in message
...
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

hours and minutes multiplied by wage
 

See previous post.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Tom" wrote in message
...
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

hours and minutes multiplied by wage
 

PLEASE POST YOUR QUESTION ONCE AND ONLY ONCE!

This is your third posting of the same problem.

See my answer to your first post

"Tom" wrote:

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