Hi,
Joeu2004
Quote:
That's because some of the "times" in C2:C39 exceed 24 hours.
|
I see only 8 hrs as most
Quote:
But really, I suspect the data in C2:C39 is not entirely correct.
For example, C2 8 days plus 8 hours (8:00:00).
|
I don’t understand, I click C2 and its not saying B2+ 08:00:00
B
Quote:
ut B2 is simply 8 (hours?). So I suspect the 8 days is incorrect.
|
I manually typed the hh:mm:ss into C to represent hrs for the hours in B
B2 is 8 hrs, you say 8 days.
You lost me I’m afraid.
Quote:
Similarly with C3. But C4 is correctly just 1 hour (1:00:00), and B4 is 1.
So I suspect the root cause of the problem is an inconsistency in converting column B (decimal hours) into column C (Excel time).
|
Marcia, I see I have a column sorting out the 00:15:00 thanks.
so edit that out of my response
Dbenz