Time Variable (elasped time) calculations

  • Thread starter Thread starter Sonny Spears
  • Start date Start date
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.
 
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.
 
Back
Top