S
Steved
Hello from Steved
I would like to convert 9:15 to 9.15 (Decimal).
Thank you in Advance
I would like to convert 9:15 to 9.15 (Decimal).
Thank you in Advance
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
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)
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)
N
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
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
J
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
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
G
Guest
Hello from Steve
Thanks very much. Just what I wanted
Cheers Folks
Thanks very much. Just what I wanted
Cheers Folks