I didn't get it

[Guest]

What is wrong with this formula =IF(C5 <= 40, "ok", "not")

c5 = 65:00 (65 hours 00 minutes) but it is still showing me ok

 

[Biff]

Hi!

65:00 is a formatted value.

Temporarily change the format to GENERAL and see what you
get!

=IF(C5<40/24,"OK","NOT")

Biff

 

[Bob Phillips]

=IF(C5 <= TIME(40,0,0), "ok", "not")

--

HTH

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

 

[Harald Staff]

Another:
=IF(C5 <= 40/24, "ok", "not")


(40 is 40 days, not 40 hours.)

HTH. Best wishes Harald

 

[Guest]

I already figure out this problem but anyway thank u
I got another question
d2= 8:00 hours, d3= 7:00, d4 = 9:11 hours

d6 (cell format number) = =SUM(D24)*24 ( this formula suppose to add all
the hours from d2 to d3) but instead of getting 24:11 hours I am getting 24:18

How I can figure out that?

 

[Myrna Larson]

With that data I get 24:11. You must have a typo somewhere.

 

[Guest]

I don't have any typo

With that data I get 24:11. You must have a typo somewhere.

 

[Myrna Larson]

Then why do you get the "wrong answer"? The data you included in youir message
totals 24:11.

 

[Guest]

I don't know bro
Can u do me a favor and send me excel file which work right way.
My e-mail is (e-mail address removed)
Sincerely,

Sunny