| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert number to text and format it. | Excel Worksheet Functions | |||
| convert number to text and format it. | Excel Worksheet Functions | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
| Help Q: Entering 7 p time format, does not convert to 19:00 | Excel Discussion (Misc queries) | |||
| Convert text file to MS_Excel | Excel Discussion (Misc queries) | |||
Linear Mode
