hat
Pou egzanp ou gen yon tan nan 2: 23: 42, ou ka konvèti tan sa a èdtan pa miltipliye 24 (oswa miltipliye 1440 a minit, miltipliye 86400 pou segonn; nan lòt mo, nou ka aplike fòmil la = F2 * 24 pou konvèti tan an èdtan, = F2 * 1440 a minit, = F2 * 86400 nan segonn), ak Lè sa a, chanje selil la fòmil nan fòma Nimewo. Men, ak Kutools pou Excel a Konvèti Tan sèvis piblik, ou ka yon sèl klike sou pakèt konvèti miltip done tan èdtan / minit / segonn sèlman nan Excel. Karakteristik plen gratis jijman 60-jou!
eng
For example you have a time of 2:23:42, you can convert this time to hours by multiplying 24 (or multiplying 1440 to minutes, multiplying 86400 to seconds; in other words, we can apply the formula =F2*24 for converting the time to hours, =F2*1440 to minutes, =F2*86400 to seconds), and then change the formula cell to Number format. But, with Kutools for Excel’s Convert Time utility, you can one click to batch convert multiple time data to hours/minutes/seconds only in Excel. Full Feature Free Trial 30-day!