I want to make a custom cell format, that will show for a difference of two cells with date-time data as "X days Yh" or just "Yh" if the difference is less than 24 hours and I after some effort, the best effect i get is with this format code:
Code: Select all
[>=2]##" days" "h";[>1]##"day" "h";H "h"
I have attached spread sheet with sample data.
Is there a way to make it work as I need?