Geraint Parry
Original Poster
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))

Details
Sheets,Mac OS,Personal use
Locked
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
Recommended Answer
Eric Maccabi
Silver Product Expert
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
Eric Maccabi
Silver Product Expert
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
Geraint Parry
Original Poster
Jan 17, 2023
Hi,

I can confirm it works on Sheets without the array part, but still not in Excel?
Eric Maccabi
Silver Product Expert
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
3648803656379178082
true
Search Help Center
true
true
true
true
true
35
false
Search
Clear search
Close search
Main menu