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

mrprog77

New Member
Joined
Jan 22, 2019
Messages
1
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
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
6,008
Office Version
365
Platform
Windows
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
 
L

Legacy 436357

Guest
Hi,

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

Excel Workbook
ABCDE
1SundayMondayTuesdayWednesday
2Start Drive110:30
116:00
119:12
120:10
3End Drive
116:00
119:12
120:10
 
4Total Drive5:303:120:58
Sheet1
 

Watch MrExcel Video

Forum statistics

Threads
1,099,029
Messages
5,466,116
Members
406,468
Latest member
Toto Li

This Week's Hot Topics

Top