This project is read-only.

DisplayedText

Nov 7, 2015 at 9:03 PM
Hello
I have a formula of difference in dates: C3=01/10/2015 12:00:00 am and D3=01/10/2015 11:59:59 pm with the custom format: dd "days," hh "hours and "mm" minutes. "

The result should show (= D3-C3): 00 days, 23 hours and 59 minutes. and shows: 30 days, 23 hours and 59 minutes.

Is there any way to display the text as shown in cell ???