Thread
:
How do I convert hh:mm:ss to an absolute number (26:01:32 to 26)?
View Single Post
#
2
Posted to microsoft.public.excel.misc
[email protected]
Posts: n/a
How do I convert hh:mm:ss to an absolute number (26:01:32 to 26)?
I do it with a cell format. In the custom format I use:
[h];@ It trims it down to just the hour.
Reply With Quote
How do I convert hh:mm:ss to an absolute number (26:01:32 to 26)?