HP Pavilion 9...; win 10;
C:\fakepath\SLEEP_Tm.ods Please focus your attention on the last two, [30, 31] Rows. I purposely did Not enter new data … SO WHY SUCH A LARGE DIFFEDRENCE ?
Thank you!
Hello,
probaby because in fact you did not add day times in cells B30 and B31 they contain
B30: 43:45:00 and
B31: 67:45:00
(same thing for cell C31, which is 47:55:00, D31 (26:21:00), E31 (27:40:00)
which aren't times of a day, but time differences (Time of a day must be less or equal 1)
Hope that helps
The reason is that OP simply drag-copies times down, without noticing that this operation adds 24 hours to each cell with date/time.
The rest I'd like to add has already be done by @Mike Kaganski 's answer, which crossed with my first version of the my answer. Sorry @Mike Kaganski...
Please don't be sorry: crossing answers are not something to ask excuses for - we all try to help others! Thank you (and me ;-P) for that!
When working with durations, never (yes, never!) use wall time format like HH:MM; always use duration formats like [HH]:MM, which will easily show your problems.
And when working with times, be aware that drag-copy operations on numbers (and times) typically increase numbers by one: test with a cell with value 1, and drag-copy it down (select the cell and use mouse to drag the small dot in the bottom right part): it will turn 2. When a time cell (with something like "19:45", which is actually a number like 0.822916666666667 formatted like a time) is dragged down, it is also incremented by 1. But having formatting in the cell like "HH:MM", which is possibly something you actually need here (if you register some wall time here), you won't see that added 1 (which would be 1 whole day), and only see "19:45" again, without realizing that the value is now much greater.
Mike;
I certainly thank you for making me aware of these issues. It's clear, I need to do some serious learning
- especially on Time FORMATS.
Can you recommend a worthy text ? gripWin@gmail.com
The full format code syntax is described in our help.
Have I ever mentioned [HH: SS], i.e. square brackets around the whole format??? Have you paid attention to what was written/suggested to you - i.e. [HH]:MM with only most significant part bracketed?
To not add the 1 to the number while drag-copying, you need to press Ctrl while releasing mouse button.
Asked: 2019-11-13 13:22:16 +0100
Seen: 64 times
Last updated: Nov 13 '19
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
