Hi,
is there any way i can calculate the hours column in the attached doc by using the date & time columns?
Hi,
is there any way i can calculate the hours column in the attached doc by using the date & time columns?
Perhaps:
C8: =24*(SUM($A8:$B8)-SUM($A7:$B7))
Dates in XL are integers and Time is decimal (ie noon = 0.5, 6am = 0.25 etc...) this is how/why we can add the two values together and subsequently subtract/add as we would any other number.
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)
Bookmarks