Time to Decimal point

[Steved]

Hello from Steved

I would like to convert 9:15 to 9.15 (Decimal).
Thank you in Advance

 

[Frank Kabel]

Hi
if you only want to change the delimiter you may use a custom format
like
hh.mm
for this cell.
If you want to convert it to a decimal value I'd assume that 9.25 would
be your desired result?
use
=A1*24
to achieve this (format the resulting cell as number)

 

[Nicky]

Hi

Assuming you want to convert the data value 9:15 to the number 9.15
this may be what your're after, assuming the date value 9:15 is in cel
A1

=HOUR(A1)+MINUTE(A1)/10

 

[JE McGimpsey]

Do you need to convert? If you only need to display, you can use

Format/Cells/Number/Custom and enter h.mm


If you need to convert:

A1: 9:15
B1: =INT(A1*24)+MOD(A1*24,1)*0.6

Format B1 as General or a number format.

An alternative:

B1: =HOUR(A1)+MINUTE(A1)/100

 

[Guest]

Hello from Steve

Thanks very much. Just what I wanted

Cheers Folks