smide
Board Regular
- Joined
- Dec 20, 2015
- Messages
- 162
- Office Version
- 2016
- Platform
- Windows
Hello.
In columns B and C (B2:B600, C2:C600) I'm receiving dates (with hours and minutes) in rather strange form - without current year?
For example in cell B2: 12.02. 19:07
Explanation: 12 - day, 02 - month (February), then after 02. there is a one space, 19 - hours, 07 - minutes
In cell C2: 14.02. 11:05
I need to calculate difference between dates C2-B2 in hours.
Note: all those dates have the same year 2018
Example:
<tbody>
</tbody>
In columns B and C (B2:B600, C2:C600) I'm receiving dates (with hours and minutes) in rather strange form - without current year?
For example in cell B2: 12.02. 19:07
Explanation: 12 - day, 02 - month (February), then after 02. there is a one space, 19 - hours, 07 - minutes
In cell C2: 14.02. 11:05
I need to calculate difference between dates C2-B2 in hours.
Note: all those dates have the same year 2018
Example:
A | B | C | D | |
1 | ||||
2 | 12.02. 19:07 | 14.02. 11:05 | C2-B2 (in hours) | |
3 | .... | .... | .... | |
4 | .... | .... | .... |
<tbody>
</tbody>
Last edited: