Format decimal to specific type of format

**DonkeyOte** · 02-25-2011, 06:28 AM

Not clear if you want B2 to be 24.15 or 24:15 format as 24.15 - the two are very different values.

For 24.15 as Decimal

=DOLLARFR(A2,60)

(DOLLARFR requires activation of Analysis ToolPak pre XL2007)

or

=INT(A2)+MOD(A2,1)*0.6

If you want B2 as hours but format as though decimal then:

=A2/24
format as [hh].mm

**greekboyuk** · 02-25-2011, 08:59 AM

Hi DonckeyOte,

Thanks for your help. I used the "INT" and "Mod" formula and it works fine however the problem that I have is when I enter a negative value it is not converting it correctly. e.g

A2= 5.5 (converts it to 5.30) which is great
A2= -5.5 (converts it to 5.70) which is not correct for me. It should change it to -5.30

Can we do that please?

Many Thanks