Hello,
Is there a way to fill columns X and Z by selections made in cells V4, V7, and V10.
I have manually entered for Start at 12:00 am, End at 11:59 pm, with duration of 15 minutes.
Thank you for your help
Hello,
Is there a way to fill columns X and Z by selections made in cells V4, V7, and V10.
I have manually entered for Start at 12:00 am, End at 11:59 pm, with duration of 15 minutes.
Thank you for your help
in X4
Formula:Please Login or Register to view this content.
in Z4
Formula:Please Login or Register to view this content.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Remove ALL expected results first, then in X4:
=SEQUENCE(ROUNDUP((V7-V4)/(V10/24/60),0),,V4,V10/24/60)
and in Z4:
=SEQUENCE(ROUNDUP((V7-V4)/(V10/24/60),0),,V10/60/24,V10/60/24)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thank you both @JohnTopley and @AliGW. 2 great methods with expected results.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks