Payroll calculation problem

[TheMyth]

I am attempting to enter the employees start time, end time, the
compute the number of hours worked, multiply this number by the hourl
wage to get gross pay in dollars.

Example:

Cell A1 is start time =time(14,30,0) 2:30 pm
Cell B1 is end time =time(19,0,0) 7:00 pm
Cell C1 calculates time worked =b1-a1 4:30
Cell D1 is the hourly wage $7.00

The total goes in cell E1 and should be =c1*d1 = $31.50, but I kee
getting 1.3125. Can someone please help me straighten this out.

Thanks.

TheMyt

 

[raymondsum]

I suggest in cell C1, you type =(B1-A1)*24 as one day has 24 hours an
change C1 as Value.

HTH

Raymon

 

[TheMyth]

Raymond:

Thanks, problem solved.

TheMyt

 

[Viss]

I have a similar problem Im trying to calculate cell E18(which is i
time format 00:00) with cell C22 which is in currency. The formula
used is =E18*C22 and in the total box I keep getting the time come u
as the total Please help my project is nearly finished and
need this ;

 

[Frank Kabel]

Hi
try
=E18*24*C22
and format the target cell as number/currency

Also format the cell E18 in the correct time format: hh:mm

 

[Viss]

Thank you for your help the formular worked purfect :