Convert time into integer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Timecard functions and formulas 1
Payroll calculations for real time 2
calculate overtime at 2 different rates 5
Time x Rate 2
over time in a sheet 2
Conditional Function 2
Rounding cents 3
overtime calculation 3

Back
Top