Convert time into integer
 

how can i convert time into integer, like i m working on a overtime sheet
where i need to calculate the time difference and then multiply with they
amount per hour (an integer) to calculate the actual amount of working.

Convert time into integer
 

Hi Ali

Time is store by Excel as fractions of a day.
Multiply your hours*24 to convert them to decimal hours, then multiply that
by the rate per hour.

Regards

Roger Govier


Ali wrote:
how can i convert time into integer, like i m working on a overtime sheet
where i need to calculate the time difference and then multiply with they
amount per hour (an integer) to calculate the actual amount of working.