Payroll calculation problem

T

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
 
R

raymondsum

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

HTH

Raymon
 
V

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 :rolleyes: Please help my project is nearly finished and
need this ;
 
F

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
 
Top