How do I convert time format to text?

[Andrew]

I have a cell with a formula of =text(c3-b3,"h:mm") as the difference from
cell b3 and c3. Assume the result is 5:00. I need to minus another cell value
that is formatted as general text. eg. =text(c3-b3,"h:mm")-G3

Thanks....Andrew

[CyberTaz]

Hi Andrew-

Try the VALUE() fx and format that cell with your choice of Time Formats.

HTH |:>)

"Andrew" wrote:

> I have a cell with a formula of =text(c3-b3,"h:mm") as the difference from
> cell b3 and c3. Assume the result is 5:00. I need to minus another cell value
> that is formatted as general text. eg. =text(c3-b3,"h:mm")-G3
>
> Thanks....Andrew