Custom format cell

[ElmerS]

Hi,

I like to subtract one date from another.
The two dates look as: dd/mm/yyyy hh:mm
I know how to achieve that with a little more sophisticated formula than a simple subtraction like in column C.
However I'm curious about achieving that by only custom formatting leaving the formula Intact.
I am familiar with the [h]:mm format but could not make [d] [h]h:mm work.
Thanks, Elm

[DonkeyOte]

I knew I said I wouldn't but...

You can't show cumulative days (above 31) in XL like you can minutes, seconds.

If you want in one cell then you have (as you infer) no option but to return as a text string, ie:

=INT(B3-A3)&" "&TEXT(MOD(B3-A3;1);"hh:mm")

[ElmerS]

Thanks, but as I have stated - I am familiar with more than one possible formula to achieve that.
I will wait for more replies regarding custom formatting only.
Elm

[DonkeyOte]

No problem - good luck with that ... but as stated, you can't show cumulative days via Custom Formatting - the option simply does not exist - however I accept there is no need to take my word for it.

(and I did state: "as you infer", )

[ElmerS]

Not fair,

You edited your first post and added the statement.
It wasn't there when I first read and replied.

I will take your word for it...
Thanks.

[DonkeyOte]

In fairness I edited my post before your reply - you can see the time in the Edit box (Edit completed a full 8 minutes before your reply)

I'm not one for editing my posts if it throws the continuity of the thread later on... the edit in question was merely so that the formula reflected your locale (ie comma to semi colon)

I would be the first to admit that I did edit the narrative after I initially posted it but that was pre 18:07 UK time - ie almost immediately (and I do this a lot because my spelling alone is woeful!)