how to use hour() on above 24 hours?

N

nicomatos

Hi
I have a problem: I need to set excel to tell me how much will a pa
someone who has worked 26:30:00 hours if he gets 10$ an hours.
The problem is that I can't use the hour() function, because it return
me only 2 hours since 26:30:00 appears like "01/01/1900 2:30:00"
If someone could help me with this, it would be very easy since th
function would just be "hour()*10+minute()*10/60".
Thanks
 
B

Bob Phillips

format it as [h]:mm

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
B

BenjieLop

nicomatos said:
Hi
I have a problem: I need to set excel to tell me how much will a pa
someone who has worked 26:30:00 hours if he gets 10$ an hours.
The problem is that I can't use the hour() function, because it return
me only 2 hours since 26:30:00 appears like "01/01/1900 2:30:00"
If someone could help me with this, it would be very easy since th
function would just be "hour()*10+minute()*10/60".
Thanks.
Click to expand...

Assuming A1 contains the hours (in the format that you presented) an
B1 contains the hourly rate, do this in Cell C1:

1. Format the cell in $
2. Enter the formula =A1*24*B1

In your example, you should get an answer of $265.00
 
Top