Lost my mind - I don't know where it fits, please read and help if you can

[mrprog77]

OK, so I am trying to perform an action on Hours:Minutes in which climb higher every day. What I am trying to accomplish is better shown than to use words, but I will try both.

Ok, so in words,

I drove a total of 110 hrs and 30 minutes (110:30) thus far. On Monday, if I drive 5 hrs and 30 minutes (5:30). I would enter 116:00
On Tuesday, I drive for 3 hrs and 12 minutes (3:12), I would enter 119:12 and get the result of 3:12. So and So Forth.

I know it looks confusing... below is what I am trying to accomplish and what it should resemble in excel...

Monday
Start Drive 110:30
End Drive 116:00
Total Drive 5:30

Tuesday
Start Drive 116:00
End Drive 119:12
Total Drive 3:12

Wednesday
Start Drive 119:12
End Drive 120:10
Total Drive 00:58


See, that makes more sense. LoL… Any help you can provide is great and very much appreciated.

Thank You in Advance.
MrProg

 

[Yongle]

Format the cells with NumberFormat \ CustomFormat \ [h]: mm
Enter values including the colon ( : )

Excel 2016 (Windows) 32 bit

	I​	J​	K​	L​	M​
1​	Monday				Formula in K
2​	Start Drive 110:30		110: 30​		value entered
3​	End Drive 116:00		116: 00​		value entered
4​	Total Drive 5:30		5: 30​		=K3-K2
5​
6​	Tuesday
7​	Start Drive 116:00		116: 00​		=K3
8​	End Drive 119:12		119: 12​		value entered
9​	Total Drive 3:12		3: 12​		=K8-K7
10​
11​	Wednesday
12​	Start Drive 119:12		119: 12​		=K8
13​	End Drive 120:10		120: 10​		value entered
14​	Total Drive 00:58		0: 58​		=K13-K12

Sheet: Sheet1

 

[Legacy 436357]

Hi,

You first need to format the cells custom like this "[h]:mm". Then hopefully this is what you want:

Excel Workbook
	A	B	C	D	E
1		Sunday	Monday	Tuesday	Wednesday
2	Start Drive	110:30	116:00	119:12	120:10
3	End Drive	116:00	119:12	120:10
4	Total Drive	5:30	3:12	0:58
Sheet1