Thread: Change a specific figure i.e 0:00 and 24:00 to display as "MIDT"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
  
Posts: 2,389
Default Change a specific figure i.e 0:00 and 24:00 to display as "MIDT"
=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?

Reply With QuoteReply With Quote