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
|