I cant figure out why i can't get 8 hours regular with the MIN function. Please help
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Help with this simple excel formula
0
Answers
0
Hi BATDUDE1976 and welcome to the forum,
You just need to make a small change to your formula.
In "K17 you have =MIN(8,K16). Change this to =MIN("8:00",K16).
I have attached your file with this change in "L17"
Cheers :-)
Discussion
Hi BATDUDE1976,
Did you try my recommended change? Did it solve your issue?
If so, please mark my answer as Selected.
Did you try my recommended change? Did it solve your issue?
If so, please mark my answer as Selected.
WillieD24 (rep: 557) Dec 21, '23 at 3:26 pm