Jan 16, 2023
Array Formula In Excel
I currently have an hours worked calculator in excel that converts to decimal, but I need to have an Excel version as well. How would I convert the below formula to work in Excel?
=ARRAYFORMULA(SUM(HOUR(D2)+minute(D2)/60,-E2))
Details
Community content may not be verified or up-to-date. Learn more.
All Replies