tree5ppm
New Member
- Joined
- Nov 20, 2021
- Messages
- 1
- Office Version
- 2021
- 2019
- 2016
- Platform
- Windows
- MacOS
Hello fellows,
Thank you for great forum that helps most of the formula doubts.
in my case. A2 has 2019-03-10 14:30
A3 has 2021-11-21 05:00
I would like to get results in B4 like "986 days, 14 hours, 30 minutes"
in B5 "2 years, 8 months, 10 days, 14 hours, 30 minutes"
in B6 "32 months, 10 days, 14 hours, 30 minutes"
Kind Regards
Thank you for great forum that helps most of the formula doubts.
in my case. A2 has 2019-03-10 14:30
A3 has 2021-11-21 05:00
I would like to get results in B4 like "986 days, 14 hours, 30 minutes"
in B5 "2 years, 8 months, 10 days, 14 hours, 30 minutes"
in B6 "32 months, 10 days, 14 hours, 30 minutes"
Kind Regards