It depends on the values you have. A time to Excel is a fraction of a day
(ie, 24 hours = 1). So if, for example, your times are always less than 12
hours, and your heights are always greater than 0.5, you can take advantage
of this by using a custom format like:

[<0.5]h:mm;#,##0.00

This will display all your times as h:mm, and all your heights as 0.00

Regards,
Fred

"kafter244" wrote in message
...
I am using VLOOKUP to find a "time" result from a "height" input, and (in
another condition) the reverse of this.

The input and output cells work in both circumstances, however I must
change
the number formatting each time to reflect wether I am inputting (or
returning) a time ("00:00") or a regular integer (0.00).

Is there a function I can use whereby I do not need to change this
formatting...or the formatting changes itself relative to the same
condition
as the formula?