Change Duration From 12h 12m to 14412 minutes

Z

zickamirul

New Member
Joined
Mar 27, 2021
Messages
2
1616835969369.png

Hi guys, need help here, i would like to change the duration from the screenshot above, 10h 12m change to minutes.
and also if 1d 17h 26m to minutes.
1616836057347.png

Hope someone could help me here.
Thanks in advance.
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Sort by date Sort by votes
Welcome to MrExcel message board.
Then 12 Hours 12 min equal to 732 minutes. why & how you calclulate 14412 minutes.
For first situation select all column then go to Home Tab, then number format , custom format and at Type Section write: [mm]
 
Upvote 0
maabadi said:
Welcome to MrExcel message board.
Then 12 Hours 12 min equal to 732 minutes. why & how you calclulate 14412 minutes.
For first situation select all column then go to Home Tab, then number format , custom format and at Type Section write: [mm]
Click to expand...
i have try what u advised, its not changing.
maabadi said:
Welcome to MrExcel message board.
Then 12 Hours 12 min equal to 732 minutes. why & how you calclulate 14412 minutes.
For first situation select all column then go to Home Tab, then number format , custom format and at Type Section write: [mm]
Click to expand...

my mistaken convert 12h 12m to 14412 minutes.

buy i try what you have advised, its not changing.
Zabbix history 1-26 March 2021.xlsx
ABCDE
1DowntimeUptimeDurationStatus
226/3/2021 1:0526/3/2021 11:1710h 12mRESOLVED
312/3/2021 3:1312/3/2021 13:2710h 14mRESOLVED
426/3/2021 4:3726/3/2021 15:0210h 25mRESOLVED
514/3/2021 0:3714/3/2021 11:1910h 42mRESOLVED
616/3/2021 18:3716/3/2021 18:4710mRESOLVED
73/3/2021 18:413/3/2021 18:5110mRESOLVED
81/3/2021 9:541/3/2021 10:0410mRESOLVED
923/3/2021 19:1023/3/2021 19:2010mRESOLVED
1021/3/2021 15:4521/3/2021 15:5510mRESOLVED
1115/3/2021 10:3015/3/2021 10:4010mRESOLVED
121/3/2021 22:491/3/2021 22:5910mRESOLVED
1311/3/2021 16:3311/3/2021 16:4310mRESOLVED
147/3/2021 12:357/3/2021 12:4510mRESOLVED
156/3/2021 16:486/3/2021 16:5810mRESOLVED
1612/3/2021 16:1312/3/2021 16:2310mRESOLVED
179/3/2021 16:209/3/2021 16:3010mRESOLVED
1826/3/2021 1:5826/3/2021 2:0810mRESOLVED
1921/3/2021 15:5721/3/2021 16:0710mRESOLVED
2019/3/2021 14:4419/3/2021 14:5410mRESOLVED
2124/3/2021 10:1924/3/2021 10:2910mRESOLVED
221/3/2021 19:051/3/2021 19:1510mRESOLVED
O&M


Zabbix history 1-26 March 2021.xlsx
ABCD
1DowntimeUptimeDuration
226/3/2021 1:0526/3/2021 11:1710h 12m
312/3/2021 3:1312/3/2021 13:2710h 14m
426/3/2021 4:3726/3/2021 15:0210h 25m
514/3/2021 0:3714/3/2021 11:1910h 42m
616/3/2021 18:3716/3/2021 18:4710m
73/3/2021 18:413/3/2021 18:5110m
81/3/2021 9:541/3/2021 10:0410m
923/3/2021 19:1023/3/2021 19:2010m
1021/3/2021 15:4521/3/2021 15:5510m
1115/3/2021 10:3015/3/2021 10:4010m
121/3/2021 22:491/3/2021 22:5910m
1311/3/2021 16:3311/3/2021 16:4310m
147/3/2021 12:357/3/2021 12:4510m
156/3/2021 16:486/3/2021 16:5810m
1612/3/2021 16:1312/3/2021 16:2310m
179/3/2021 16:209/3/2021 16:3010m
1826/3/2021 1:5826/3/2021 2:0810m
1921/3/2021 15:5721/3/2021 16:0710m
2019/3/2021 14:4419/3/2021 14:5410m
2124/3/2021 10:1924/3/2021 10:2910m
221/3/2021 19:051/3/2021 19:1510m
231/3/2021 17:041/3/2021 17:1410m
2412/3/2021 8:3812/3/2021 8:4810m
2510/3/2021 10:5710/3/2021 11:0710m
2625/3/2021 16:2125/3/2021 16:3110m
275/3/2021 21:085/3/2021 21:1810m
285/3/2021 19:335/3/2021 19:4310m
2911/3/2021 3:2011/3/2021 3:3010m
307/3/2021 21:448/3/2021 9:1411h 30m
318/3/2021 4:048/3/2021 15:0911h 5m
328/3/2021 19:038/3/2021 19:1411m
3315/3/2021 15:3815/3/2021 15:4911m
3410/3/2021 11:1010/3/2021 11:2111m
3510/3/2021 10:0710/3/2021 10:1811m
3624/3/2021 16:0124/3/2021 16:1211m
3721/3/2021 19:0421/3/2021 19:1511m
3813/3/2021 14:4913/3/2021 15:0011m
3912/3/2021 11:0212/3/2021 11:1311m
406/3/2021 18:516/3/2021 19:0211m
416/3/2021 18:136/3/2021 18:2411m
4217/3/2021 13:4517/3/2021 13:5611m
4319/3/2021 16:0919/3/2021 16:2011m
4418/3/2021 14:1418/3/2021 14:2511m
4515/3/2021 19:4115/3/2021 19:5211m
467/3/2021 9:057/3/2021 9:1611m
475/3/2021 18:315/3/2021 18:4211m
4825/3/2021 15:0425/3/2021 15:1511m
4920/3/2021 15:4720/3/2021 15:5811m
5020/3/2021 14:0020/3/2021 14:1111m
5110/3/2021 10:0910/3/2021 10:2011m
5210/3/2021 9:1210/3/2021 9:2311m
5320/3/2021 15:0920/3/2021 15:2011m
5426/3/2021 0:2926/3/2021 0:4011m
5514/3/2021 10:4814/3/2021 10:5911m
5614/3/2021 11:3514/3/2021 11:4611m
5720/3/2021 8:3320/3/2021 8:4411m
5811/3/2021 3:2611/3/2021 3:3711m
594/3/2021 12:314/3/2021 12:4211m
6011/3/2021 15:0511/3/2021 15:1611m
6116/3/2021 7:5316/3/2021 8:0411m
6216/3/2021 1:0916/3/2021 1:2112m
6324/3/2021 11:4324/3/2021 11:5512m
641/3/2021 11:441/3/2021 11:5612m
6522/3/2021 8:0122/3/2021 8:1312m
6621/3/2021 17:5121/3/2021 18:0312m
6718/3/2021 19:5818/3/2021 20:1012m
6817/3/2021 20:2717/3/2021 20:3912m
697/3/2021 10:037/3/2021 10:1512m
709/3/2021 12:289/3/2021 12:4012m
7114/3/2021 17:0214/3/2021 17:1412m
7211/3/2021 2:2111/3/2021 2:3312m
7319/3/2021 19:2719/3/2021 19:3912m
7421/3/2021 14:4621/3/2021 14:5812m
7516/3/2021 11:4516/3/2021 11:5712m
7613/3/2021 12:2713/3/2021 12:3912m
7710/3/2021 6:3610/3/2021 6:4812m
782/3/2021 14:432/3/2021 14:5512m
791/3/2021 0:131/3/2021 0:2512m
8022/3/2021 12:3922/3/2021 12:5112m
8123/3/2021 14:1423/3/2021 14:2612m
8221/3/2021 12:3421/3/2021 12:4612m
8321/3/2021 12:3621/3/2021 12:4812m
8420/3/2021 3:5120/3/2021 4:0312m
859/3/2021 5:199/3/2021 5:3112m
8610/3/2021 14:1410/3/2021 14:2612m
8719/3/2021 14:3519/3/2021 14:4712m
889/3/2021 8:499/3/2021 22:0213h 13m
897/3/2021 19:238/3/2021 9:1413h 51m
908/3/2021 15:218/3/2021 15:3413m
918/3/2021 13:548/3/2021 14:0713m
928/3/2021 15:108/3/2021 15:2313m
938/3/2021 15:138/3/2021 15:2613m
943/3/2021 18:003/3/2021 18:1313m
9517/3/2021 20:0317/3/2021 20:1613m
967/3/2021 3:097/3/2021 3:2213m
9726/3/2021 15:2826/3/2021 15:4113m
9824/3/2021 0:2724/3/2021 0:4013m
9919/3/2021 8:3519/3/2021 8:4813m
10012/3/2021 9:4612/3/2021 9:5913m
1018/3/2021 17:198/3/2021 17:3213m
1027/3/2021 13:467/3/2021 13:5913m
1035/3/2021 12:595/3/2021 13:1213m
10423/3/2021 14:5623/3/2021 15:0913m
10516/3/2021 18:1316/3/2021 18:2613m
1062/3/2021 11:352/3/2021 11:4813m
10721/3/2021 10:2821/3/2021 10:4113m
10822/3/2021 8:5322/3/2021 9:0613m
10911/3/2021 23:0411/3/2021 23:1713m
11010/3/2021 12:1810/3/2021 12:3113m
1117/3/2021 21:027/3/2021 21:1513m
11215/3/2021 15:3415/3/2021 15:4713m
11313/3/2021 2:1013/3/2021 2:2414m
1142/3/2021 13:322/3/2021 13:4614m
1153/3/2021 22:123/3/2021 22:2614m
1166/3/2021 4:416/3/2021 4:5514m
1179/3/2021 10:049/3/2021 10:1814m
11811/3/2021 10:1011/3/2021 10:2414m
1196/3/2021 13:326/3/2021 13:4614m
1205/3/2021 17:515/3/2021 18:0514m
12119/3/2021 17:3219/3/2021 17:4614m
12217/3/2021 9:0717/3/2021 9:2114m
1237/3/2021 12:127/3/2021 12:2614m
12424/3/2021 15:5924/3/2021 16:1314m
12521/3/2021 18:4622/3/2021 10:1115h 25m
1267/3/2021 20:068/3/2021 11:3815h 32m
12716/3/2021 15:2716/3/2021 15:4215m
12811/3/2021 2:0311/3/2021 2:1815m
12924/3/2021 17:4024/3/2021 17:5515m
1304/3/2021 15:484/3/2021 16:0315m
1311/3/2021 9:481/3/2021 10:0315m
1326/3/2021 18:006/3/2021 18:1515m
1335/3/2021 20:235/3/2021 20:3815m
1345/3/2021 15:465/3/2021 16:0115m
13512/3/2021 2:3612/3/2021 2:5115m
13610/3/2021 11:2410/3/2021 11:3915m
1374/3/2021 9:534/3/2021 10:0815m
13826/3/2021 16:0326/3/2021 16:1815m
13921/3/2021 17:3421/3/2021 17:4915m
14013/3/2021 0:5713/3/2021 1:1215m
14125/3/2021 23:2725/3/2021 23:4215m
1429/3/2021 13:409/3/2021 13:5515m
14323/3/2021 13:5423/3/2021 14:0915m
1444/3/2021 16:384/3/2021 16:5315m
1452/3/2021 11:242/3/2021 11:3915m
14624/3/2021 20:3024/3/2021 20:4515m
14714/3/2021 14:5914/3/2021 15:1415m
14810/3/2021 9:0210/3/2021 9:1715m
1492/3/2021 20:142/3/2021 20:2915m
1501/3/2021 9:441/3/2021 9:5915m
15116/3/2021 1:1916/3/2021 17:2616h 7m
1522/3/2021 19:222/3/2021 19:3816m
1536/3/2021 6:326/3/2021 6:4816m
15419/3/2021 12:1019/3/2021 12:2616m
15521/3/2021 19:4421/3/2021 20:0016m
15619/3/2021 21:4319/3/2021 21:5916m
15716/3/2021 13:0316/3/2021 13:1916m
15818/3/2021 20:0618/3/2021 20:2216m
15911/3/2021 10:0511/3/2021 10:2116m
16026/3/2021 12:3226/3/2021 12:4816m
16126/3/2021 11:4926/3/2021 12:0516m
16212/3/2021 9:2012/3/2021 9:3616m
16317/3/2021 18:4418/3/2021 11:5517h 11m
16422/3/2021 15:3923/3/2021 8:4317h 4m
16519/3/2021 20:0420/3/2021 14:0117h 57m
1662/3/2021 19:213/3/2021 12:2917h 8m
1676/3/2021 16:456/3/2021 17:0217m
16825/3/2021 11:3525/3/2021 11:5217m
16925/3/2021 11:0925/3/2021 11:2617m
17010/3/2021 15:5510/3/2021 16:1217m
1716/3/2021 19:156/3/2021 19:3217m
17224/3/2021 1:4024/3/2021 1:5717m
1739/3/2021 16:309/3/2021 16:4717m
1748/3/2021 18:118/3/2021 18:2817m
17513/3/2021 7:0113/3/2021 7:1817m
1766/3/2021 8:156/3/2021 8:3217m
17716/3/2021 10:1616/3/2021 10:3317m
17813/3/2021 16:1213/3/2021 16:2917m
1793/3/2021 12:423/3/2021 12:5917m
1803/3/2021 11:153/3/2021 11:3217m
1815/3/2021 14:415/3/2021 14:5817m
1822/3/2021 14:292/3/2021 14:4617m
18326/3/2021 16:4026/3/2021 16:5717m
18421/3/2021 22:0821/3/2021 22:2517m
1855/3/2021 18:575/3/2021 19:1417m
1866/3/2021 19:186/3/2021 19:3517m
18716/3/2021 0:2216/3/2021 18:4218h 20m
18823/3/2021 16:4924/3/2021 11:3818h 49m
18916/3/2021 10:3816/3/2021 10:5618m
19013/3/2021 9:3413/3/2021 9:5218m
1916/3/2021 22:016/3/2021 22:1918m
19221/3/2021 18:1821/3/2021 18:3618m
19321/3/2021 16:2121/3/2021 16:3918m
1944/3/2021 16:184/3/2021 16:3618m
1954/3/2021 14:434/3/2021 15:0118m
19620/3/2021 9:3320/3/2021 9:5118m
19711/3/2021 17:3411/3/2021 17:5218m
1983/3/2021 21:353/3/2021 21:5318m
19922/3/2021 17:0822/3/2021 17:2618m
20018/3/2021 5:5418/3/2021 6:1218m
20119/3/2021 17:1519/3/2021 17:3318m
20223/3/2021 2:4523/3/2021 3:0318m
2032/3/2021 17:132/3/2021 17:3118m
2047/3/2021 11:087/3/2021 11:2618m
20515/3/2021 7:2915/3/2021 7:4718m
20611/3/2021 10:2411/3/2021 10:4319m
2073/3/2021 12:183/3/2021 12:3719m
2082/3/2021 7:282/3/2021 7:4719m
20911/3/2021 2:4111/3/2021 3:0019m
21010/3/2021 11:3410/3/2021 11:5319m
21120/3/2021 16:0420/3/2021 16:2319m
21219/3/2021 19:4919/3/2021 20:0819m
21324/3/2021 13:5424/3/2021 14:1319m
21411/3/2021 11:5911/3/2021 12:1819m
2151/3/2021 6:451/3/2021 7:0419m
2169/3/2021 0:309/3/2021 0:4919m
2174/3/2021 11:294/3/2021 11:4819m
21818/3/2021 12:1118/3/2021 12:3019m
21918/3/2021 17:5218/3/2021 18:1119m
22016/3/2021 16:2816/3/2021 16:4719m
2211/3/2021 16:011/3/2021 16:2019m
22223/3/2021 21:2725/3/2021 14:531d 17h 26m
22313/3/2021 4:4614/3/2021 22:351d 17h 49m
22410/3/2021 11:2811/3/2021 12:331d 1h 5m
2258/3/2021 10:589/3/2021 15:301d 4h 32m
2265/3/2021 9:246/3/2021 17:391d 8h 15m
22715/3/2021 16:4215/3/2021 17:521h 10m
2284/3/2021 14:214/3/2021 15:331h 12m
2292/3/2021 16:332/3/2021 17:461h 13m
2306/3/2021 0:316/3/2021 1:451h 14m
23111/3/2021 2:2111/3/2021 3:351h 14m
23210/3/2021 2:1810/3/2021 3:341h 16m
23321/3/2021 19:0621/3/2021 20:231h 17m
23411/3/2021 2:2111/3/2021 3:401h 19m
2357/3/2021 19:327/3/2021 20:331h 1m
O&M
 
Upvote 0
How are the duration values entered into the sheet?

From your original screen capture it would have been a fair assumption that they were valid times returned from a formula in the cell. In the mini sheets that you have provided, we can see that they are actually text strings which can not be formatted.

If the duration is calculated with a simple formula such as =B2-A2 then the suggested method of formatting will work.
zickamirul said:
my mistaken convert 12h 12m to 14412 minutes.
Click to expand...
As @maabadi has already informed you, 12h 12m is actually 732 minutes, so how are you arriving at a result of 14412?

We can not provide the right answer if you ask the wrong question.
 
Upvote 0
You must log in or register to reply here.

Similar threads

W
  • Question
Show Error message If result not within 5% of figure in seperate table
Replies
2
Views
202
Woodpusher147
W
S
  • Solved
Filter Various Columns & Have Them Stacked
Replies
8
Views
63
Fluff
Fluff
S
  • Solved
Advanced(?): Excel formula to calculate duration based on three activity levels with reset for each change of level
Replies
8
Views
599
skm95
S
T
  • Question
Try to calculate the max borrowing power for a client using a cell for funds available towards purchase and a max LVR
Replies
3
Views
47
totalegazy
T
S
  • Solved
Formula to minus 3 Hours from Days, Hours & Minutes
Replies
3
Views
327
Alex Blakenburg
A

Forum statistics

Threads
1,215,029
Messages
6,122,755
Members
449,094
Latest member
dsharae57

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top