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

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

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

Original Poster

Jan 17, 2023

Hi,

I can confirm it works on Sheets without the array part, but still not in Excel?

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?

Search

Clear search

Close search

Main menu