excel

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

Excel

resolvedResolved · Low Priority · Version 2003

Any has attended:
Excel Intermediate course

Excel

what would be the best calculation to use when trying to calculate hours of work over two different days. eg. starting at 0800 mon and finishing at 0300 tue. and be able to repeat this for the full range of possible hours.

RE: excel

Hello

Thank you for your question and welcome to the forum.

This was a very challenging question which has a few of our trainers scratching their heads, hence the delay in response.

I think we have a solution that will work - see below (it will help to put the start and finish times and formula into a spreadsheet to see how this works.

An option for calculating dates, as doesn


 

Excel tip:

Toggle Formulas and Results

Ctrl + 'The key above Tab with the

View all Excel hints and tips


Server loaded in 0.08 secs.