“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I need to find the time taken between two cells in Days, Hours & Minutes. Although I have the formula it converts into US and shows the days higher than it should.

Solved by B. B. in 25 mins

Can you please help me with a formula that will convert ---> 7 days 22 hours 51 minutes 27 seconds 630 milliseconds
to the format dd:hh:mn:sec?

Solved by X. Q. in 23 mins

I need help. Cell AB is supposed to calculate how long a repair has taken. I want it to show the days, hours and minutes a repair takes. At the moment it shows the hours and doesn't show the days nor minutes.
Cell AB is calculated by working out the difference between two dates then from that answer anything in cell W and Z is deducted

Solved by E. W. in 21 mins

I need to put dd:hh:mm:ss 12:13:30:30 into a cell or cells where is reads as
12 days 13 hours 30 minutes 30 seconds. I need the numbers and text in the same cell.

Solved by F. A. in 22 mins

Column AB has a formula that takes dates and times from cells F and Q and works out the difference and shows it in day hours and minutes. I need the formula to take off weekends and also deduct the days hours and minutes in cells W and Z because at the moment it doesn't

Solved by I. J. in 27 mins