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.
 
Top