Dual Formats in a Single Cell

[lpsnyc]

I have a simple spreadsheet that has two inputs...Distance and Time.
I want to display two possible results in the third cell...either Minutes per Mile or Speed.
The problem is Min/mile is in TIME format while SPEED is in number format.

How do I have dual formats in this cell depending on whether the column title reads Min/Mile or Speed?
I have the formulas for Min/Mile and Speed already calculated based on the column title.

If column C title reads Min/Mile, then format is in TIME format

If column C title reads Speed, then format is in NUMBER format

Thanks
Lance

 

[Fluff]

You could use conditional formatting to set the format based on the value in C1

 

[lpsnyc]

Hi Fluff
Thanks for the suggestion. I tried Conditional formatting based on the value in C1 but it does not give me the option to format as time.
Any other suggestions?

Thanks

 

[Fluff]

In conditional formatting click on format & then Custom, Time

 

[lpsnyc]

Thank you

 

[Fluff]

You're welcome & thanks for the feedback.