Decimal minute

[Steved]

Hello from Steved

I have decimal time 9.30

Please A formula to .30 of the 9.30 to decimal minute for
the hour hence .30 is .50 so in this case 9.30 will be 9.50

at the moment I have 9+30/60 which converts to 9.50

Thankyou

 

[Ron Rosenfeld]

Hello from Steved

I have decimal time 9.30

Please A formula to .30 of the 9.30 to decimal minute for
the hour hence .30 is .50 so in this case 9.30 will be 9.50

at the moment I have 9+30/60 which converts to 9.50

Thankyou

With 9.3 in A1:

=INT(A1)+MOD(A1,1)/0.6

--ron

 

[Steved]

Thankyou.

-----Original Message-----


With 9.3 in A1:

=INT(A1)+MOD(A1,1)/0.6

--ron
.

 

[Harlan Grove]

I have decimal time 9.30

Please A formula to .30 of the 9.30 to decimal minute for
the hour hence .30 is .50 so in this case 9.30 will be 9.50

at the moment I have 9+30/60 which converts to 9.50

An alternative: with decimal time in cell G1, try

=24*SUBSTITUTE(G1&"0",".",":")

 

[Steved]

Hello Harlan from Steved

Harlan i type in using your formula 9.30 returns 9.50
which it is supposed to do but I type in 9.45 returns
16.50 it should be 9.75, question what formating should I
be using with your formula please.

Thankyou.

 

[Harlan Grove]

Harlan i type in using your formula 9.30 returns 9.50
which it is supposed to do but I type in 9.45 returns
16.50 it should be 9.75, question what formating should I
be using with your formula please.

....

I was trying to be too clever and wasn't clever enough.

Try this instead,

=24*TEXT(G1*100,"#\:00")

 

[Steved]

Hello from Steved

=24*TEXT(G1*100,"#\:00")

In cells with no values it displays #Values!.
Is it possible please just to diplay a blank cell.

Thankyou

 

[JE McGimpsey]

One way:

=IF(G1<>"",24*TEXT(G1*100,"#\:00"),"")

 

[Steved]

Thanks JE

-----Original Message-----
One way:

=IF(G1<>"",24*TEXT(G1*100,"#\:00"),"")


.

 

[Steved]

Thanks JE

-----Original Message-----
One way:

=IF(G1<>"",24*TEXT(G1*100,"#\:00"),"")


.