Calculate gross pay

G

Guest

I enter start and end times (cell formated for time), subtract to find total
hours, and multiply by rate of pay. The result doesnt make any sense. What am
I doing wrong?
 
N

Niek Otten

Since time is stored as a fraction of a day, multiply your result by 24 and
format as anything but time, probably Currency

--
Kind regards,

Niek Otten

Microsoft MVP - Excel
 

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

How do I calculate total pay from pay rate times hours and minutes 4
Need to work hours backwards 10
Formula for Calculating Pay 1
Payroll - net to gross? 3
Convert Time to Number 1
Calculating Times for Pay Rates 4
row of $ numbers don't crossfoot 2
Construct staff pay timesheet 1

Top