Transcribing time data into a worksheet & having trouble getting the formats and values I need for formulas.
I have a start date and time and end date and time. All four values are in different (but sequential) columns. I need to use these values to get the total time lapsed (the time extends overnight, so the end date is always greater and the time is always less).
Then I have four columns of blocks of time (hours & min, though it may be 0 hrs); these need to be added to verify they make up the entire time block, and each block needs to be calculated as a percentage of the whole.
Any help is greatly appreciated!
I have a start date and time and end date and time. All four values are in different (but sequential) columns. I need to use these values to get the total time lapsed (the time extends overnight, so the end date is always greater and the time is always less).
Then I have four columns of blocks of time (hours & min, though it may be 0 hrs); these need to be added to verify they make up the entire time block, and each block needs to be calculated as a percentage of the whole.
Any help is greatly appreciated!