I don't have any typo
"Myrna Larson" wrote:
With that data I get 24:11. You must have a typo somewhere.
On Mon, 21 Feb 2005 19:45:03 -0800, "Sunny"
wrote:
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(D2:D4)*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?
"Biff" wrote:
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
-----Original Message-----
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
.
|