what format to use to show days in hours

[wayneg]

Hi all,

i have a worksheet with

=SUMIF(AO4:AO67,"Total Lates",AP4:AP67)

in a few cells. this formula works well for what i want it to, but what format do i use to show days in hours. i have got HH:MM but sometimes that just shows 06:26 instead off 30:26 (1 day 6 hours and 25 minutes).

could you please advise me.


thanks

[Pepe Le Mokko]

Try custom formatting as [h]:mm

[wayneg]

that worked, thanks