Reading excel in time dominations

Resolved · Low Priority · Version 2007

Thu 12 Dec 2013, 15:29 Delegate Nicole said...

Nicole has attended:
Excel Introduction course

Reading excel in time dominations

i was wondering if you could read/work in time values? as an exapmmle 1.5 standing for an hour and a half (90 mins)

Thu 12 Dec 2013, 16:52 Trainer Gary said...

RE: reading excel in time dominations

Hi Nicole

Thanks for getting in touch. Yes you can do this, Excel prefers it if you write 1.5 hours like this:

01:30

You can also right click the cell and choose Format Cells to see more time formatting styles.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best 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

Thu 19 Dec 2013: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Make a quick copy of a worksheet

Hold down the Ctrl key, then click and drag on a sheet tab to make a copy of that sheet. Though this process usefully copies the formats of the original sheet, note that any Range Names you have on the original sheet will be duplicated too.

To make a copy of a worksheet's contents and formats without duplicating range names: (1) Ensure that you have a blank worksheet to paste to. (2) On the sheet to copy, click on the sheet selection square to the left of Column A's heading to select the whole sheet. (2) Copy the whole sheet. (3) Paste to the blank worksheet.

View all Excel hints and tips