Time Variable (elasped time) calculations

S

Sonny Spears

Trying to calculate gross pay using calculated elasped
(WORK)time using time variables for SIGN IN & SIGN OUT.
WORK calculates correctly but can not then use it to get
gross pay.
 
B

Bob Phillips

Sonny,

Multiply iut by 24 before multiplying by pay rate, and format as a number
not time, as Excel holds time as a fraction of 1 day.
 

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 calculate elasped time 2
Time elapsed calculation 6
convert [h]:mm:ss to real number that I can use as a multiplier 3
Federal tax withholding calculations - using IF statements..? 12
Need Elapsed Time Help 2
Using Percent 2
Total Elasped Time 3
how do I stop payroll tax deductions once FUTA limit is met? 10

Top