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
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

I​

[/th][th]

J​

[/th][th]

K​

[/th][th]

L​

[/th][th]

M​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1​

[/td][td]Monday[/td][td][/td][td][/td][td] [/td][td]Formula in K[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td]Start Drive 110:30[/td][td][/td][td]

110: 30​

[/td][td][/td][td] value entered[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td]End Drive 116:00[/td][td][/td][td]

116: 00​

[/td][td][/td][td] value entered[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td]Total Drive 5:30[/td][td][/td][td]

5: 30​

[/td][td][/td][td]=K3-K2[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

5​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

6​

[/td][td]Tuesday[/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

7​

[/td][td]Start Drive 116:00[/td][td][/td][td]

116: 00​

[/td][td][/td][td]=K3[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

8​

[/td][td]End Drive 119:12[/td][td][/td][td]

119: 12​

[/td][td][/td][td] value entered[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

9​

[/td][td]Total Drive 3:12[/td][td][/td][td]

3: 12​

[/td][td][/td][td]=K8-K7[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

10​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

11​

[/td][td]Wednesday[/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

12​

[/td][td]Start Drive 119:12[/td][td][/td][td]

119: 12​

[/td][td][/td][td]=K8[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

13​

[/td][td]End Drive 120:10[/td][td][/td][td]

120: 10​

[/td][td][/td][td] value entered[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

14​

[/td][td]Total Drive 00:58[/td][td][/td][td]

0: 58​

[/td][td][/td][td]=K13-K12[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]

 

[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