inserting hrs and minutes

B

-Brian-H-

I have a cell in my time card that displays total weekly time -ex-
"40:15" is there a way to make it more like this...40hrs,15mins
 
F

Frank Kabel

Hi
applay the following custom format (goto 'Format - Cells'):
[hh]"hrs",mm"mins"

HTH
Frank
 
M

millsy

You can change the number format as follows:

Select your cell then choose Format>Cells>Number>Custom

Replace whatever format string is in the box below the word "Type:
with:

hh "hours" mm "minutes
 
Top