Hours to Days Hours Minutes Conversion Frustration

[TurtleontheRun]

Hello,

I have a sum of hours in [h]:mm and need to convert it to Days Hours Minutes. Just selecting a different format doesn't work (ridiculous! ) but understandable. INT and MOD I've used before but in some cases it will make say 26 hours as one day and one hour when I need it to be 1 day and 2 hours. I've used a Rounddown (=Rounddown(time/1, 1), (Rounddown(time-days)/0.042, 0) and Roundup(((Time-days-)-(Hours*0.042))/0.00069, 0) but it seems to break around either the day or minute formulas. I've supplied a simple table below to give a better idea. Any suggestions? Thanks in advance!

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Time[/TD]
[TD]Days[/TD]
[TD]Hours[/TD]
[TD]Mins[/TD]
[/TR]
[TR]
[TD]26:40[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Note:
This will eventually end in a =B2&U2&" "&C2&U3&" "&D2&U4 to end in 1d 2h 40mins

 

[Fluff]

Cell format works for me

Book1
	D	E	F	G
6	20:00	06:40	26:40:00	1d 2h 40mins
7	18:00	13:20	31:20:00	1d 7h 20mins
8	06:00	12:11	18:11:00	0d 18h 11mins
Week 28

Cell Formulas
Range	Formula
F6	=SUM(D6:E6)
G6	=F6

Format in col G is
d"d" h"h" m"mins"

 

[ParamRay]

Days : = INT( A1 )
Hours : = HOUR( A1 )
Mins : = MINUTE( A1 )

Format them all as General.

 

[TurtleontheRun]

Woks wonderfully. Simplest solutions. Thank you!

 

[Fluff]

Glad we could help & thanks for the feedback