Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

reading excel time dominations

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Reading excel in time dominations

Reading excel in time dominations

ResolvedVersion 2007

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)

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.

Excel tip:

Some examples of CTRL key shortcuts in Excel 2010

Did you know that the old CTRL key shortcuts haven't changed from previous versions of Excel to the 2010 version?

They remain exactly the same:

Ctrl+B for bold
Ctrl+I for italics
Ctrl+P to Print
Ctrl+S to Save

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.