We’d like to remind Forumites to please avoid political debate on the Forum.

This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Can you explain this Excel formula?

Wig · 2010-07-16 20:41:25

I found this formula which does a good job of solving an excel problem I had. =(INT(C4/100)+(C4-100*INT(C4/100))/60)/60/24 Format cell (with the formula in) to display mm:ss The problem was to be able to enter a set of data into excel in only mm:ss time format and then get an average. But Excel requires you to either enter…

Comments

DVardysShadow Posts: 18,949 Forumite

21 July 2010 at 8:50PM

A further point. Where I do think the programmer needs to know precedence is in the Application Domain - far more than in the Programming Domain. So I would expect a programmer to know how to translate mathematical expressions from the Application Domain which rely on precedence into code in the required language.

Hi, we’ve had to remove your signature. If you’re not sure why please read the forum rules or email the forum team if you’re still unsure - MSE ForumTeam
0

This discussion has been closed.

★ ★ ★ Meet your Ambassadors

Can you explain this Excel formula?

Comments

Confirm your email address to Create Threads and Reply

🚀 Getting Started

Categories

Is this how you want to be seen?

Get our FREE Weekly email full of deals & guides - and it’s spam-free