How do I convert time format to text?
 

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

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