Jan 16, 2023

Array Formula In Excel

Hello,

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))

Locked
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
Recommended Answer
Jan 16, 2023
It's not clear to me why this is an array formula. This seems like a simple calculation that can be done without arrayformula in the formula.

try that?
Original Poster Geraint Parry marked this as an answer
Helpful?
All Replies
Recommended Answer
Jan 16, 2023
It's not clear to me why this is an array formula. This seems like a simple calculation that can be done without arrayformula in the formula.

try that?
Original Poster Geraint Parry marked this as an answer
Jan 17, 2023
Hi,

I can confirm it works on Sheets without the array part, but still not in Excel?
Jan 17, 2023
Can you please share the sheets file so I can see the values you have in d2 and e2 and how they’re formatted?
false
2302579824707242136
true
Search Help Center
true
true
true
true
true
35
Search
Clear search
Close search
Main menu
false