adding aircraft flight time hours and minutes

Welcome to the board.

You can't manually enter time values > 9999 hours in [h]:mm format, but you can add values that give larger results:

	A	B	C
1	Flight Dur	Cumu
2		9900:32	Format of B2: [h]:mm
3	9:35	9910:07	B3: =B2+A3
4	6:08	9916:15
5	8:10	9924:25
6	8:18	9932:43
7	3:46	9936:29
8	3:33	9940:02
9	8:09	9948:11
10	7:47	9955:58
11	8:10	9964:08
12	6:37	9970:45
13	5:54	9976:39
14	5:36	9982:15
15	6:25	9988:40
16	2:00	9990:40
17	2:34	9993:14
18	6:24	9999:38
19	2:26	10002:04
20	3:38	10005:42
21	4:58	10010:40
22	3:38	10014:18

If you have...

A1 = 16352
B1 = 32

And want that to be a true time value...

=(A1/24)+(B1/1440)

Format as [h]:mm

The largest time value that can be manually entered in a cell is 9999:59:59.

However, you can get much larger time values with calculations.

whenever i try to subtract the two values I get #VALUE!

I don't see that:

	A	B	C	D
1	Flight Dur	Cumu
2		9900:32	Format of B2: [h]:mm
3	8:29	9909:01	B3: =B2+A3
4	3:55	9912:56
5	2:32	9915:28
6	6:43	9922:11
7	7:37	9929:48
8	8:02	9937:50
9	6:34	9944:24
10	5:21	9949:45
11	2:35	9952:20
12	9:14	9961:34
13	7:57	9969:31
14	8:48	9978:19
15	4:17	9982:36	44:46	C15: =B15-B8
16	2:52	9985:28
17	8:27	9993:55
18	7:05	10001:00
19	5:46	10006:46
20	5:13	10011:59
21	9:04	10021:03
22	8:30	10029:33

Maybe you could post a workbook that illustrates the problem.

	A	B	C	D
1	16352:32	17000:23	647:51	C1: =B1-A1

That's why I suggested you post a workbook.

Those are numbers stored as text, and as has been said twice in this thread, you can't manually enter times larger than 9999 hours in that fashion. So you need to use a formula for those manual input cells only.

	A	B	C
1	16352:32	17000:23	#VALUE!
2	16352:32	17000:23	647:51

	A	B	C
1	16352:32	17000:23	=B1-A1
2	=LEFT(A1, FIND(":", A1) - 1) /24 + RIGHT(A1, 2)/1440	=LEFT(B1, FIND(":", B1) - 1) /24 + RIGHT(B1, 2)/1440	=B2-A2

All the other calculations can be done in the usual way.

Or ...

	A	B
1	16352:32
2	16352:32	A2: =DOLLARDE(SUBSTITUTE(A1, ":", "."), 60)/24
3		Format of A2: [h]:mm

You're welcome.

@perigi

Unfortunately your post does not comply with Rule 4 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.