Excel question

[Guest]

Is it possible to "convert" HOUR into an Integer number and how do I do this
Application is for simple payroll whereby I need to separate basic hours (say eight) from overtime hrs and then want to use the outcome to calculate pay earned
Thanks; Harry

 

[Mark W.]

On 2002-02-28 09:26, Anonymous wrote:
Is it possible to "convert" HOUR into an Integer number and how do I do this
Application is for simple payroll whereby I need to separate basic hours (say eight) from overtime hrs and then want to use the outcome to calculate pay earned
Thanks; Harry

Since there are 24 hours in a day, a time value which is stored as a fractional part of a day can be converted into hours by multiplying it by 24. For example, if cell A1 contains the time value for 8:30 PM, the formula, =A1*24, will produce 20.5 hrs.

"Basic" hours can be calculated using...

=MIN(A1*24,8)

"Overtime" hours can be calculated using...

=MAX(A1*24-8,0)