inserting hrs and minutes

[-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

 

[Peo Sjoblom]

Use a custom format hh"hrs",mm"mins"

 

[Frank Kabel]

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

HTH
Frank

 

[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