I can’t figure out how to enter time values without AM or PM. Like, a certain number of hours:minutes
Hello,
this is not a question of “how to enter time values” but a question of “how to display entered time values”. And changing the representation of data (of a specific data type [1] ) is formatting cells (and there is a default format for each locale). Having said this:
Method 1 Change Cells Format
- Select a cell (or a complete range of cells) having times
Right click -> Format Cells...-> Tab: Numbers- Select
Timein Category - Use Format Code:
HH:MM:SS
Method 2 Change Locale
You can globally change your locale to one, which doesn’t have an AM/PM standard and which is more appropriate for you.
Tools -> Options -> Language Settings -> Languages -> Locale setting: e.g English (UK)
This locale has a default HH:MM:SS without AM/PM. Please note that changing the locale globally also has effects on other defaults, such as currency symbols, date acceptance pattern and more …
[1] To avoid a common misunderstanding: Formatting data is no method to change a data type. Formatting changes the representation within a data type but never changes the data type itself. Numeric data keep to be numeric data and data type “Text” is textual data regardless of any format applied to cell(s) after input.
Hope that helps
There is still the fundamental conflict concerning “time” as TimeOfDay vs. “time” as duration.
The standard formats are made for TOD, but pretend to also be appropriate for durations.
Using them for durations, however, we need to accept the doubtable hard-coded unit d (day) which comes with all the complications of administered calendaric date-time.
If durations calculated from TOD values probably afflicted by DST issues are relevant, no standard means exist. Otherwise durations must be formatted with an [H] or [HH] (Regard the square brackets!) to avoid the suppression of the integer part (full days of 24 hours each). In addition the mentioned formats always show the values rounded down like digital clocks and watches do.
I woud suggest to make the use-case obvious by formatting duration cells with
[H]" h "MM" min "SS" s" where the seconds part may be omitted. This will still allow to enter a time using 13:15 as a shorthand for 3 h 15 min.
Thank you both very much. “Method 1” works fine, so I won’t worry about the other methods.
I am wondering, though, whether the spreadsheet is able to add and subtract time amounts. I haven’t seen anything to suggest that it can. Say, if I work a job from 12:39 pm to 3:52 pm, would the time sheet be able to figure out the time amount I worked?
Thanks if you know the answer to that!
Please do **not** use *Add Answer* if you actually don't answer a question but commenting an answer or responding to another user’s comment. Please use ***add a comment*** for that purpose. Thanks in advance …
Regarding your question: This site is full of answers related to **time differences** an associated problems if you don't have a starting date and ending date as well. The simlest method is `=B1-A1` if `A1` has a starting date + time and `B1` has an ending date + time. Then simply format as "[HH]:MM" and you get the duration (square backets "'[ ]`" are important here, to allow for more than 24 hours to be displayed)
Finally: *If the answer is helpful please consider to click the check mark (✔) next to the answer. Thanks in advance ...*