How to achieve a cell format like 26:30 (meaning 26 hours, 30 minutes), without seconds? Such format is not predefined. There is only 26:30:00 or 26:30,0 in the program settings available.
2
-
Use custom formatting?– JerryCommented Mar 26, 2014 at 7:29
-
For sure, but how? Already tried with hh:mm, but it is clock time (entering 26:00 changes to 02:00)– Liglo AppCommented Mar 26, 2014 at 7:29
Add a comment
|
1 Answer
You need to use the one that is for timespans not for dates. [h]:mm would be the format definition in your case.
answered Mar 26, 2014 at 7:37
