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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
excel

ResolvedVersion 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:

Create and delete borders

To put a border around the outside of a selected range, press Ctrl+Shift+&. Use Ctrl+Shift+_ (underscore) to remove any borders from a range.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.