I’m trying to format cells in a worksheet to accept numbers as elapsed
time for a project requiring time tracking. For instance, 15:00 (fifteen
hours) is showing up as 3:00:00 PM in the formula bar. The standard
cell formatting options do not offer the format I need, however it is
available in the custom cell formatting options, but when I select it, it
does not apply to the cell. The Help says to use/type format code
[h]:mm to show elapsed time, but, how do I do that? More specifically,
where do I enter a format code? What am I not getting? (Perhaps I need
more coffee…)
Thanks in advance for any help that can be offered.
