Add text to a formula

Topic

New Reply

=SUM(E4:E8) I have this formula and the cell formatted to Time, It currently equates to 0:50 I would like it to add text Hours and Minutes to the end IE 0:50 0 0 Hours 50 Minutes and as the time increase to Hours and Minutes.

Many Thanks in advance

Reply | Quote

Replies

I’m not entirely clear what you want in the cell but I imagine a variation of this custom number format:
h” hours” mm “minutes”

Reply | Quote

Hi Rory

That’s exactly what I needed

Thanks very much
Braddy

Reply | Quote