Microsoft Excel – Formulae and Functions working with Dates and Times

Date/Time: Thursday, 15th April 2021 - 2:00 pm - 2:45 pm

Location: Online

Available Spaces: 15

Contact Details: Marc Watson: marc.watson@nhs.net

Description

This course will show you some very useful formulae and functions when dealing with dates.

  • Adding dates
  • Calculating number of days/months/years between 2 dates
  • Calculating working days
  • Date functions
    • Date
    • Day
    • Month
    • Year
    • Finding the name of a day or month from a date
  • Adding whole months to a date
  • Calculations with Times
    • Adding and subtracting hours
      • How to display the results correctly
  • Time functions
    • Time
    • Hour
    • Minute

Please be aware that the session is booked for 30 minutes and the extra 15 minutes are for any questions which may occur. You are not obligated to stay for the full 45 minutes.


You need to be logged in in order to be able to register for this event.

[ultimatemember form_id="3621"]