HP Pavilion 9…; win 10;
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!
HP Pavilion 9…; win 10;
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!
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
Mike;
I did change the frmts > [HH: SS] - NO observable difference.
Drag’ng down. and adding a day, as you explained, does skew the value. Is there a way to cancel that?
Or how should a new line be formed?
I value your help greatly, Thanks!
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.
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 @mikekaganski 's answer, which crossed with my first version of the my answer. Sorry @mikekaganski…
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!