Excel

Resolved · Urgent Priority · Version 2013

Thu 22 Sep 2016, 16:16 Delegate Stella said...

Stella has attended:
Presentation Skills course

Excel

I would like some help in reformatting some excel spreadsheet but cannot have it doe publicly will it be possible to get get in tuch with me on: stella@spana.org ?
Thanks

Thu 22 Sep 2016, 16:40 Trainer Richard said...

RE: Excel

Hello Stella,

Hope you enjoyed your course with STL Training.
Thank you for your question regarding Excel.

If you would send your spreadsheet and summary of what you want help with to forum@stl-training.co.uk, we can take a look and advise how to proceed.

Kind regards,

Richard

Thu 22 Sep 2016, 16:43 Delegate Stella said...

RE: Excel

Ok will do

Fri 23 Sep 2016, 12:48 Trainer Richard said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Mon 26 Sep 2016, 09:25 Delegate Stella said...

RE: Excel

Hi Doug,

Could you lease give me a call on 02072692695 as I am not sure about the job you've sent seems that you are using the old template instead of the new one?

Thanks

Stella

Training courses

	98.7 % recommend us
	More live stats...

Training information:

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