As an example
![]()
F6: =IF(COUNT($C6:$D6)<2,"",MOD(TEXT($D6,"00\:00")-TEXT($C6,"00\:00"),1))
As an example
![]()
F6: =IF(COUNT($C6:$D6)<2,"",MOD(TEXT($D6,"00\:00")-TEXT($C6,"00\:00"),1))
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Congratulations, you did it.
Thank you. I don't quite understand the formula, but will try to decipher it.
Thanks again for your time and expertise.
I did want to mark this post as 'solved' but I can't remember how to do it
Last edited by nje; 08-08-2011 at 01:58 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks