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

Calculating payroll cost 1
I need calculated time in a "real number" format 2
Sum Time 6
Time x Rate 2
Negative time calculations 4
Time format 2
Timecard question 5
how do I calculate a week days hours with the 24hour clock 5

Top