excel

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

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

Excel

resolvedResolved · Urgent Priority · Version 2013

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

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

RE: Excel

Ok will do

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.

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


 

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


Server loaded in 0.09 secs.