LearnMeExcel
Well-known Member
- Joined
- Aug 11, 2009
- Messages
- 746
- Office Version
- 365
- 2021
- Platform
- Windows
hi
how i can convert 6:15 to 6.25 and 18:15 to 6:25
how i can convert 6:15 to 6.25 and 18:15 to 6:25
Excel Workbook | ||||
---|---|---|---|---|
E | F | |||
12 | 06:25 | 6.25 | ||
13 | 18:25 | 6:25 PM | ||
Sheet1 |
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 |
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")) |