LinkBack URL
About LinkBacks
tarsuc 
@tarsuc, if the values are as you say they are then:
should work without issue (even with the likes of 11 am etc...)
=MOD(B1-A1,1) format as h:mm
If you get errors with the above apply TRIM to B1 & A1 ... failing that post a sample file.
@tarsuc, if the values are as you say they are then:
should work without issue (even with the likes of 11 am etc...)=MOD(B1-A1,1) format as h:mm
If you get errors with the above apply TRIM to B1 & A1 ... failing that post a sample file.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks