excel formulas

[elynoy]

Hello. I'd like to know if it possible to multiply a cell value converted to [h] with euro formated cell.

For exemple I have a cell with 88 formated as [h] and I want to multiply it by normal value "5.1" and retrieve the value in "euro" format.


exemple 88*5.1=448.8
but if I format the result as [h] or standard or any other value the result will not be the 448.8.

I hope I explained myself good enought.
Thanks in advance
eLy

 

[James006]

Hello,

You should try

=(88/24)*5.1

Hope this will help

 

[elynoy]

Beent trying to format in numerous ways.. so simple as add another *24 in it gosh I feel dumb.

Thank you

Best regards,
eLy

 

[James006]

You are welcome ...:wink: