C clobus New Member Jan 20, 2012 #1 I have time listed as 6:48:47 AM, but want to display it as 6h 49m. I have not been able to format the cell to appear like this. Is there a format that I am missing or a formula that can help me do this? Thank you. Chris
I have time listed as 6:48:47 AM, but want to display it as 6h 49m. I have not been able to format the cell to appear like this. Is there a format that I am missing or a formula that can help me do this? Thank you. Chris
C clobus New Member Jan 20, 2012 #3 There needs to be one more " after the second h (should read h"h" m"m"), but this works! Thank you very much!!! Greatly appreciate your help. Chris
There needs to be one more " after the second h (should read h"h" m"m"), but this works! Thank you very much!!! Greatly appreciate your help. Chris
