Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas

Formulas

ResolvedVersion 2010

Wed 30 May 2018, 16:38 Delegate Agatha said...

Agatha has attended:
Excel Intermediate course

Formulas

Is there a way to write a formula that expresses specific times as fractions?

Thu 31 May 2018, 09:22 Edited on Thu 31 May 2018, 09:22 Trainer Jens said...

RE: Formulas

Hi Agatha,

Thank you for the forum question.

If you select the time and change the formatting to Fraction, the time will be displayed as a fraction. If you want the time displayed as decimals change the formatting to Number.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Ctrl+d's double life

Suppose I have a formula in B1 that I wish to copy into B2:B10. I can select B1:B10 then press Ctrl+d to copy the formula down the selected range. Users generally ignore this shortcut in favour of double-clicking on the fill handle to copy down, but Ctrl+d is useful sometimes particularly when there is no data in surrounding columns to guide to how far the double-click method should copy formulae.

Ctrl+d has another use though. When I use the drawing toolbar to draw objects such as Text Boxes, Rectangles and Ovals onto a worksheet, Ctrl+d makes an instant duplicate of selected shapes. For example, I need five Text Boxes the same size. I draw one Text box and adjust it to the size I want, select it, then press Ctrl+d four times to get four identical copies.

View all Excel hints and tips

Formulas

Formulas

RE: Formulas

Excel articles

Excel tip:

Ctrl+d's double life