Formula to Convert the minutes to Decimals in a Word Table

10 30
To copy the above cell(Repeat here) (= 10) To Convert the above to Decimal MINS (= .50)

=SUM(ABOVE) Hi all I would like some help. Using a WORD Table I would like a formula that would convert MINS to decimal Mins. The table above is a nut shell of the two formulas I require. =Sum(above) 1 = .02

Mod. Moved from Excel

 

Question Info


Last updated November 25, 2019 Views 761 Applies to:
Answer
Answer

As I said:

Of course if there's only one cell, you could get away with:

{=INT(SUM(ABOVE))+ROUND(MOD(SUM(ABOVE),1)/0.60,2)}

Simply put that formula in each of the cells.

Note: The field brace pairs (ie '{ }') for the above example are created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message.

Cheers
Paul Edstein
(Fmr MS MVP - Word)

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.