Formula to Convert date

[LearnMeExcel]

hi
how i can convert 6:15 to 6.25 and 18:15 to 6:25

 

[Richard Schollar]

Multiply by 24

 

[scottylad2]

If your using them in caluculations, the top formula will need to be incorporated if your adding or subtracting hours, but this works for the top one and the 18:25 will merley need formatted as time and select the format that shows your desire output

Excel Workbook
	E	F
12	06:25	6.25
13	18:25	6:25 PM
Sheet1

 

[Weaver]

ADD 10/1440 (or 1/144)

Which equates to 10 minutes (there being 1440 minutes in a day)

=A1 + 1/144

 

[scottylad2]

Maybe I misunderstood your requirement, is it decimal times you require, ie 6:30 displayed as 6.50 etc

 

[AlphaFrog]

Excel Workbook
	A	B
1	6:15	6:25
2	18:15	6:25
Sheet

 

[LearnMeExcel]

thanx all
Richard
i did as u said

Excel Workbook
	A	B	C	D	E	F
1		Richard	Weaver	Weaver	Alpha	the Correct result
2	06:15	6.25	06:25	06:25	06:25	6.25
3	18:15	18.25	18:25	18:25	06:25	6.25
4	02:30	2.5	02:40	02:40	02:25	2.5
5	14:30	14.5	14:40	14:40	02:25	2.5
Sheet1

Excel 2010

Cell Formulas
Range	Formula
B2	=A2*24
B3	=A3*24
B4	=A4*24
B5	=A5*24
C2	=A2+1/144
C3	=A3+1/144
C4	=A4+1/144
C5	=A5+1/144
D2	=A2+10/1440
D3	=A3+10/1440
D4	=A4+10/1440
D5	=A5+10/1440
E2	=MOD(A2,0.5)-(MOD(A2,1/24)-("00:25:00"))
E3	=MOD(A3,0.5)-(MOD(A3,1/24)-("00:25:00"))
E4	=MOD(A4,0.5)-(MOD(A4,1/24)-("00:25:00"))
E5	=MOD(A5,0.5)-(MOD(A5,1/24)-("00:25:00"))

the result from 18:15 is 18.25 not 6.25 i want too ignore 24 system
in column F the Result which i am trying to get

thanx for all

 

[AlphaFrog]

Excel Workbook
	A	B
1	06:15	6.25
2	18:15	6.25
3	02:30	2.5
4	14:30	2.5
Sheet

 

[LearnMeExcel]

THANX ALPHA
that is what i am looking for
but please could you explains why you use the mod on 0.5
thanx

 

[AlphaFrog]

It ignores 24 system, or it returns the remainder after dividing by 0.5 (half a day).