PS Where would I enter these formulas?? i.e conditional formatting or cell
format?? Cheers

"Fred Smith" wrote:

=if(mod(a1,1)=0,"MIDT","Not MIDT")

Regards,
Fred.

"Jason M" <Jason wrote in message
...
I'm trying to get a cells to show the word "MIDT" when a time figures 0:00
and 24:00 are entered in the cell! Can anyone help me?