formula for Hours and minute to number of days

[Lukma]

Hi Guys

Am little having trouble with this and i don't if am right but still i need a solution to convert the hours for each name in Column J4 to days and at end to give me the total days
i have tried using 24 to Divide each hours but still am not to sure if it right

Appreciate if someone can assist with this in simple ways

ILSP_Performance Tracking Data.xlsx
	I	J	K
3	Location Site	Total Hours	Days
4	Barge Bahia	10:5
5	Barge Scirocco	29:34
6	Barge Shamal	30:20
7	Compact Driller	27:35
8	Deep Driller-2	21:15
9	Deep Driller-3	16:6
10	Deep Driller-6	61:25
11	Rig Al Bzoom	114:20
12	Rig Al Gharbia	52:12
13	Rig Al Hail	43:40
14	Rig Al Ittihad	21:36
15	Rig Al Lulu	38:13
16	Rig Al Yasat	24:28
17	Rig Artabhatt-1	90:18
18	Rig Butinah	74:20
19	Rig Diyina	31:59
20	Rig Essa	74:24
21	Rig High Island-7	31:40
22	Rig Junana	57:55
23	Rig Makasib	112:33
24	Rig Marawwah	51:51
25	Rig Muhaiyimat	16:30
26	Rig Qarnin	38:20
27	Rig Shuweihat	116:25
28	Rig SMS Faith	56:6
29	Rig Sms Mariam	38:40
30	Rig Yemillah	49:46
31	Total Days	1331:36	0.00
Rough Total

Cell Formulas
Range	Formula
J4:J30	J4	=SUMIFS($G$4:$G$107,$B$4:$B$107,I4)
J31:K31	J31	=SUM(J4:J30)

 

[maabadi]

1. Change Total Hours Column Number format to Custom and at type section write : [h]:mm
2. Change Days Number format to General or Number. and write at K4:

=J4

and Drag it down.

Book2
	I	J	K
3	Location Site	Total Hours	Days
4	Barge Bahia	10:05:00	0.42
5	Barge Scirocco	29:34:00	1.23
6	Barge Shamal	30:20:00	1.26
7	Compact Driller	27:35:00	1.15
8	Deep Driller-2	21:15:00	0.89
9	Deep Driller-3	16:06:00	0.67
10	Deep Driller-6	61:25:00	2.56
11	Rig Al Bzoom	114:20:00	4.76
12	Rig Al Gharbia	52:12:00	2.18
13	Rig Al Hail	43:40:00	1.82
14	Rig Al Ittihad	21:36:00	0.90
15	Rig Al Lulu	38:13:00	1.59
16	Rig Al Yasat	24:28:00	1.02
17	Rig Artabhatt-1	90:18:00	3.76
18	Rig Butinah	74:20:00	3.10
19	Rig Diyina	31:59:00	1.33
20	Rig Essa	74:24:00	3.10
21	Rig High Island-7	31:40:00	1.32
22	Rig Junana	57:55:00	2.41
23	Rig Makasib	112:33:00	4.69
24	Rig Marawwah	51:51:00	2.16
25	Rig Muhaiyimat	16:30:00	0.69
26	Rig Qarnin	38:20:00	1.60
27	Rig Shuweihat	116:25:00	4.85
28	Rig SMS Faith	56:06:00	2.34
29	Rig Sms Mariam	38:40:00	1.61
30	Rig Yemillah	49:46:00	2.07
31	Total Days	1331:36:00	55.48
Sheet1

Cell Formulas
Range	Formula
K4:K30	K4	=J4
J31:K31	J31	=SUM(J4:J30)

 

[Lukma]

Thanks so Much

i did same, as i was doubting if am right or wrong but it s

I appreciate thanks

 

[maabadi]

You're Welcome & Thanks for feedback.