TIME X MONEY

M

MattG

I'm trying to work my payroll sheets via excel and am running into an error
when trying to multiply the hourly rate by the hours worked. I am using
excel 2007, the time is formatted to HH:MM:SS and when I for example myltiply
08:00:00 by $12 the result is $3.96, when in fact it should read $96.00. Any
suggestions or formulas would be appreciated.
 
A

Aladin Akyurek

Try...

=(A1*24)*12

where A1 houses a time value like 08:00:00.

The formula cell must be formatted as number or currency.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Work Budget Salary vs Real Time Salary 0
separating date and time 5
Conditional Time Calculation 10
Extracting just the time portion 6
Over time? 4
Help!!!! 0
Calculate elapsed time excluding specific timeframe 10
Aggregate the time data (mm/dd/yyyy:hh:mm:ss) into the 3 hours range 0

Top