I have the following cells :
| A (Start) | A+C (End) | C (Duration) |
|---|---|---|
| Friday 09/02/2024 14:00 | Wednesday 14/02/2024 14:00 | 4D 00H00 |
| Wednesday 14/02/2024 14:00 | #VALUE! | 30/12/1899 03:00:00 |
The value C1 row corresponds to a duration of 4 days and the value C2 row corresponds to a duration of 3 hours.
The format used for A and B is "dddd dd/mm/yyyy hh:mm" and that for column C is "d"D "hh"H"mm".
When I double click to edit cell C2 and type Enter, I get a "#VALUE!" error in cell B2.
I expect this :
| A (Start) | A+C (End) | C (Duration) |
|---|---|---|
| Friday 09/02/2024 14:00 | Wednesday 14/02/2024 14:00 | 4D 00H00 |
| Wednesday 14/02/2024 14:00 | Wednesday 14/02/2024 18:00 | 0D 03H00 |