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.