Excell 2003 and 2007 time

[jeff07kp]

Hi guys,

Well in my company we just migrated to the newest office but i'm having a big problem

=IF(C16=0,"",IF(AB9=AL9,"",IF(C16=A16,"",((TEXT(AB9,"HH:MM")&"/"&TEXT(Z9,"HH:MM"))))))

This formula will give me two times as hh:mm/hh:mm. The big problem is that my migrating the first time always shows as 00:00.. i.e. 00:00/15:00 any one knows why is this happening

 

[barry houdini]

Hello Jeff,

The obvious answer is that AB9 is blank. Are you sure you're referring to the correct cell? If AB9 is correct and does contain a value.....what is it? Does that cell have a formula?