I have a cell containing a time with a custom format with type h:mm AM/PM. The cell contents are displayed as: 6:55 PM
When a different cell refers to the above cell, the result is displayed as: 0.788194444444445
How can I get the result to be displayed as: 6:55 PM
Bookmarks