Convert time into integer

A

Ali

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

Roger Govier

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
 
Top