Forum Discussion
1st cell day/date... retrieves a second cell of store hours
HELP... I have a time card spreadsheet. Cell 1 has the day/date in it. I want Cell 2 to retrieve the store hours for that day. Saturday, March 18, 2023 6a-430p Sunday, March 19, 2023 7a-4...
If you're looking to calculate duration by End Time - Start Time, is it possible you can arrange your sheet to use a column for Start and a column for End? When both those times are in the same cell it requires the need to use extraction formulas to look for the numbers, pull them out, and do the math.