custom format hours and minutes

[ajm]

can anyone provide me with the correct syntax for a custom format of cells that will display the contents as (for example, 30.40) "30Hrs 40Mins"? I currently have

##"Hrs" .##"Mins"

but this only gives me 30Hrs.4Mins. i need the trailing zero.

 

[grizz]

format cells / custom

[h]" hour(s) "mm" minute(S)"

type in 1:30
should show 1 hour 30 minute(s)

 

[ajm]

thanks for your response. i am formatting a cell that holds a calculated value so the method you mention will not work. I need something that will work on a decimal number.

 

[xenou]

I'm not sure its possible with a custom number format. I can't come up with one, anyway. Seems like you require a conversion first -- decimal value to a time value or a text value.

 

[Scott Huish]

Since you're not going to be able to get rid of the decimal point in a number format, I worked it into how it is displayed. How does this work for you?

0"Hrs". 00"Min."

 

[ajm]

that will do nicely HP. I had not thought of using the zeroes like that. instead I was trying every other way using the # as a placeholder.

Cheers