Formatting Cells for Time

R

roddo

I would like to Format cells so that they display time as eg. 3hrs
30mins
Do I need to add a custom format? I
 
B

Bob Phillips

You do,

h "hrs" "mm" mins"

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top