CHARTS

Resolved · Low Priority · Version 2016

Mon 23 Jul 2018, 16:16 Delegate aBDOU said...

aBDOU has attended:
Excel Introduction course

CHARTS

EXCELL

Mon 23 Jul 2018, 16:36 Trainer Jens said...

RE: CHARTS

Hi Abdou,

Thank you for the forum question.

What would you like to know about charts?

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

Excel tip:

Calculate difference between two times

For presenting the result in the standard time format (hours : minutes : seconds . Use the subtraction operator (-) to find the difference between times, and the TEXT function to format the returned value to text in a specific number format.

Hours never exceed 24, minutes never exceed 60, and seconds never exceed 60.

=TEXT(B2-A2,"h")
Hours between two times (4)

=TEXT(B2-A2,"h:mm")
Hours and minutes between two times (4:55)

=TEXT(B2-A2,"h:mm:ss")
Hours and seconds between two times (4:55:00)

Where B2 and A2 must hold the end time and start time respectively formatted as a time format

View all Excel hints and tips

CHARTS

CHARTS

RE: CHARTS

Excel articles

Excel tip:

Calculate difference between two times