Did you actually read the info? It might make you understand that 4:45 is
not greater than 4 since 1 hour = 1/24 thus 4 hours and 45 minutes are 4/24
+ 45/24/60 meaning that even 0.5 is greater than 4:45. To convert 4:45 to a
decimal value you need to multply with 24

=E3*24=4


--


Regards,


Peo Sjoblom




"johnthebaptist" wrote in message
...
Thanks, Gord Dibben, but I don't see how this info solves my problem.

"Gord Dibben" wrote:

4:45 as a number is 0.197916667 if AM

0.697916667 if PM

For more on Excel's use of date/time serial numbers see Chip Pearson's
site.

http://www.cpearson.com/excel/datetime.htm#SerialDates


Gord Dibben MS Excel MVP

On Sun, 11 Nov 2007 10:00:00 -0800, johnthebaptist
wrote:

Excel tells me that E3=4 is FALSE, where E3=4:45, a time format, and
formatting should be ignored.

The whole formula I'm trying to work out is: =IF(E3=4,"DONE",(4-D3)).
Excel accepts this but reads 4 as 24 and returns 19:15 for (4-D3).

OK, so (E3=4) is FALSE if 4=24, but why does Excel read 4 as 24? And
how
do I get Excel to read 4 as 4:00 and return the difference between 4:00
and,
say, 3:27?