smide
Board Regular
- Joined
- Dec 20, 2015
- Messages
- 162
- Office Version
- 2016
- Platform
- Windows
Hello.
I have a spreadsheet with text cells for dates (column B) in the format dd.mm.yyyy - hh:mm
I need formula to subtact two dates. Result in minutes.
example.
I have a spreadsheet with text cells for dates (column B) in the format dd.mm.yyyy - hh:mm
I need formula to subtact two dates. Result in minutes.
example.
A | B | C | |
1 | Date 1 | 10.04.2022 - 22:00 | |
2 | Date 2 | 11.04.2022 - 01:30 | |
3 | result (Date 2 - Date 1) | 210 | |