-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
12/1/2017
-
V
Basis on start time and end time, require output in HH:MM:SS
Hi All, Need your help.. I have Start Time 12/1/2017 2:32:15 PM I have End Time 12/1/2017 6:24:38 PM and basis on this I made output this.. formula for this.. =IF($A174<>"",(B174-A174)*24*60,"") B = end time A = start time Now, requirement is, instead of this.. I want output in this...- VBABEGINER
- Thread
- 12/1/2017 end output start time
- Replies: 3
- Forum: Excel Questions
-
K
Date Lookup
Hello, [Sheet 1] as two columns. Column A [ID] and Column TIME [Sheet 2] as two columns. Column A [ID] and Column TIME [Sheet 2] holds all historical date for every ID and every occurrence in time that the ID performed a specific action. 1. What I am trying to create in [Sheet...- kparadise
- Thread
- 12/1/2017 column sheet time [sheet
- Replies: 3
- Forum: Excel Questions
-
P
formula
Hi! I'm trying to enter a formula on a master sheet that would take information from 3 workbooks and summarize the data by date, and task. Here is data for 12/1/2017, and the master sheet is below. Does anyone have any ideas? Thank ;you <tbody> West 2017: Workbook 1 Date Task Time...- pccBC
- Thread
- 12/1/2017 task telephone training travel
- Replies: 1
- Forum: Excel Questions
-
V
Countif Unique Values
Hello ! I am trying to make a counting for unique value on the same date. I've seen several formulas here and it's too complex for me to understand :(. Staff record ( Sheet 1 ) <tbody> A B C D 1 Date Staff Dep Quantity Wa Quantity 2 12/1/2017 Alex Expected value 1 Expected Value 1 3...- Velven
- Thread
- 12/1/2017 cust dep expected unique
- Replies: 1
- Forum: Excel Questions
