How do I convert time format to text?

A

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
 
C

CyberTaz

Hi Andrew-

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

HTH |:>)
 
Top