I’m making a schedule and when I input times it formats them cool, which is great! I just prefer to use 24 hour time compared to 12 hour because it makes more sense to me. However, when I type that into the calc cell it formats it in a 12 hour way (ex: 13:00 to 1:00)
Not a big deal, but is this changeable? Also I have like… very minimal experience with editing these things, I saw some stuff about changing it but it seemed very complicated 
Use a locale that supports 24 hour time, or edit the default style and change the time format to use 24 hour format.
Note that the bracketed format yields “accumulated time”, typically a duration, which is different from specifying time of day. If you want the result as a specific time of day (possibly offset to previous or next day), you should skip the brackets!
A little aside: For durations it is recommended that H/M/S suffix be used instead of colon separator, in order to distinguish the two “time aspects”. See ISO8601.
You can format Calc’s output to comply with ISO8601 recommendation, but alas, Calc will apparently not accept input of _H_M_S format. As far as I can tell, colon separated is still the only way to easily input time data, be it duration or time of day.
1 Like
how do i edit the default style?
how do I get to where you are in the first image?
NVM!!! I found it thank you!!!