inserting hrs and minutes

  • Thread starter Thread starter -Brian-H-
  • Start date Start date
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
 
Hi
applay the following custom format (goto 'Format - Cells'):
[hh]"hrs",mm"mins"

HTH
Frank
 
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
 
Back
Top